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.

  • v-lgarikapat's avatar
    v-lgarikapat
    Community Support
    7 months ago

    Mekist Thanks  for the update .

     

    • Mekist's avatar
      Mekist
      Helper III
      7 months ago

      Hello v-lgarikapat 

      I was able to do the test, it worked smoothly thank you

      • v-lgarikapat's avatar
        v-lgarikapat
        Community Support
        7 months ago

        Hi Mekist Glad to hear that, thanks for the update.

         

        Thanks,

        Lakshmi.