Hi Team, [image] Above is my column X, i have a condition that if the value of this column is greater than -1 and less than 1 , then i will replace the current value with 0 otherwise leaving the value as it is.

Use invoke code activity For Each r As DataRow In in_dt.AsEnumerable r(“Difference between Before Tax Amount”)=If((Math.Abs(CDbl(r(“Difference between Before Tax Amount”).ToString)))<1, “0”, r(“Difference between Before Tax Amount”).ToString) Next r

Update a column in a datatable using LINQ

Help Studio

ppr (Peter Preuss) August 18, 2023, 12:18pm 8

Cross Reference:

Topic		Replies	Views
Linq If Condition Studio studio , question , workflow_diff	14	1090	August 18, 2023
Linq query for updating a value in a datatable based on a condition Studio studio , question , activities_panel	10	1400	September 23, 2022
How to Update a column with 2 conditions using LINQ Studio studio , question , activities_panel	3	1754	January 27, 2022
Update a datatable column with a specific value using linq Studio studio , question , activities_panel	9	5893	September 15, 2022
Update datatable using Linq Studio datatable , linq , update	4	717	December 8, 2023

Most Active Users - Yesterday
sharazkm32
ashokkarale
V_Roboto_V
Anil_G
adilhassanpost
Hosam_Alzahrani
gorby
Sreekumar_Sedharth
adi.mehare
stary
More details...

Update a column in a datatable using LINQ

Related topics