Can any one help me in writing a query to update value as “0” in column “value” where the value is “-2.41” Need the query without using for each loop as I have 40k rows.

[image] Shilpa_Mohanty: Name try like below. (From d In dtData.AsEnumerable Let u1 = If(d(“AmtPending”).ToString.Trim.Equals(“-241”),“0”,d(“AmtPending”).ToString) Let u2 = If(d(“Amttaken”).ToString.Trim.Equals(“-241”),“0”,d(“Amttaken”).ToString) Select dtResult.Rows.Add(New Object(){d(“N…

Select query help

Help Studio

THIRU_NANI (NaNi) December 4, 2021, 6:46am 4

Have you tried with LinQ?

Regards,
NaNi

Topic		Replies	Views
LINQ query to replace column datatable in uipath Learning Hub	9	6177	August 11, 2020
LINQ query to update(replace)datatable in uipath Help datatable , excel , activities , question	8	18653	December 8, 2019
Replace specific values of all columns of datatable Studio datatable , studio , question , activities_panel , linq , invoke-code , linq-quey , excel-datatable	9	1529	September 7, 2023
Replace Excel Cell value Studio studio , question , extension	2	1310	September 27, 2021
Loop through all the cells of a datatable Something Else	4	1145	February 23, 2023

Select query help

Related topics