Filter and Update DataTable without loop

Help
, , ,
1

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
2

here you go
excell.zip (125.4 KB)
Cheers @testing_mail

3

Thanks mate !!!

1 Like
4

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