Hi Guys, Please I need a way I can Update a value in a Specific cell of a row based on the condition of a value in another specific cell of another row all in the same Datatable. For example lets say I have a datatable having 3 columns(Account, Currency and Debit Amount), the column(Currency) has …

Hi @Anifowose_Temi This is what it contains [image] datatable [image] first if - dt.AsEnumerable.Where(function(row) row(“Column1”).ToString.Equals(“NGN”)).Count>0 And dt.AsEnumerable.Where(function(row) row(“Column1”).ToString.Equals(“USD”)).Count>0 second if - dt.Rows.IndexOf(dt.AsEnumerab…

How to Update a value in a Specific cell of a row based on the condition of a value in a specific cell of another row

Help Studio

Anil_G (Anil Gorthi) November 11, 2022, 4:50pm 2

Hi @Anifowose_Temi

Please see the atatched xaml… In here I have shown how to do this by creating what you asked.

Sequence1.xaml (13.4 KB)

cheers

Topic		Replies	Views
How to update specific row value based on condition Studio studio , question , activities_panel	10	1391	August 10, 2022
Linq query for updating a value in a datatable based on a condition Studio studio , question , activities_panel	10	1476	September 23, 2022
How to update cell based on certain condition in datatable using Linq Activities excel , activities , question	5	2535	February 9, 2022
Linq - Update Values in Datatable Studio datatable , database , studio , data_manipulation	5	7656	June 20, 2020
How to update specific excel row based on other row value? Studio excel , activities , bug	7	3388	August 15, 2022

How to Update a value in a Specific cell of a row based on the condition of a value in a specific cell of another row

Related topics