Help me to understand column expression

[supermanPunch (Arpan)]

Hi @Goku ,

Check out the below blogs/Documents :

How to Update Data Column Values of a Data Table | Community Blog

DataColumn.Expression Property (System.Data)

Recent use case or Examples :

Update a column in a datatable using LINQ

Hi @yash.choursia , An Alternate with Data Column Expression (As it is an easier/simpler operation) : Implementation : [image] Here, Notice the use of Add Data Column to add another column for updating the newer values. We then use the Data Column Expression using Assign in the below Way : DT.Columns("Updated Column").Expression = "IIF(CONVERT([Difference],'System.Double')>-1 And CONVERT([Difference],'System.Double')<1,0,CONVERT([Difference],'System.Double'))" We can also simply remove t…