Forum Discussion

Mekist's avatar
Mekist
Helper III
7 months ago
Solved

If There is No Data, Continue

Hello I am pulling price information from companies; if there is no data for the company, it throws an error and does not proceed. When it encounters an error, can it continue and move on to the nex...
Need Help
  • lbendlin's avatar
    lbendlin
    7 months ago
        #"Özel İşlev Çağrıldı" = Table.AddColumn(#"Kaldırılan Sütunlar", "Fiyat Fonksiyon", each try #"Fiyat Fonksiyon (2)"([Kod]) otherwise #table({"Column1.HGDG_TARIH", "Column1.HGDG_KAPANIS", "Column1.DOLAR_BAZLI_FIYAT", "Column1.HGDG_HACIM"},{})),
lbendlin's avatar
lbendlin
Super User
7 months ago
    #"Özel İşlev Çağrıldı" = Table.AddColumn(#"Kaldırılan Sütunlar", "Fiyat Fonksiyon", each try #"Fiyat Fonksiyon (2)"([Kod]) otherwise #table({"Column1.HGDG_TARIH", "Column1.HGDG_KAPANIS", "Column1.DOLAR_BAZLI_FIYAT", "Column1.HGDG_HACIM"},{})),
Mekist's avatar
Mekist
Helper III
7 months ago

Hello lbendlin 

 

Thank you for your return.
As of now, I cannot test it since there are no companies to test it with. I will test it on January 22, 2026 and provide updates.