Filter and Update DataTable without loop

I have to read a excel(attached) and from that Datatable, I need to update column(Amount) where
column(Currency) = “AUD” then 1.4,
column(Currency) = “NZD” then 1.5,
column(Currency) = “USD” then 1.6,
without using for each.testfile.xlsx (62.5 KB)

1 Like

here you go (125.4 KB)
Cheers @testing_mail

Thanks mate !!!

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.