Dear Experts, Good Day. I need to update a column Sales Amount and Net Amount in the data table where the values are null with a 0.00 since that column is double. Reference Bank Invoice Bank Amount Sales Amount Difference Net Amount 4900067828 8203000073 -201780 4900067827 8203000072 …

[image] manjesh_kumar: AsEnumerable.ToList.ForEach @manjesh_kumar Check below for your reference [image] Invoke Code - Edit Arguments pass the datatable by direction In/Out dtoutput.AsEnumerable.Where(Function(row) row(“Column2”).ToString.Trim.Equals(“”)).ToList().ForEach(Sub(row) row(“C…

Hi @manjesh_kumar Refer to the thread below its similar to yours! [image] Using LINQ to replace specific value in DataTable without For-Each Activities Hi, this is the right side (From d In dt_Combined.AsEnumerable() Let ra = d.ItemArray.Select(Function (x) x.ToString.…

Replace null values with 0 from a data table column using LINQ

Help Studio

pravin_calvin (pravin kumar) November 1, 2021, 12:42pm 2

Hi @manjesh_kumar

Refer to the thread below its similar to yours!

Regards

Topic		Replies	Views
I would like to replace all null values with DBnull in a data table Activities database	5	2761	March 15, 2023
Replace value - with 0 in datatable Studio datatable , excel , activities , studio , question , linq	8	745	December 11, 2023
How to replace null value to 0 in a datatable without check cell by cell Help datatable	3	5564	September 14, 2020
Replace Null or empty values with static value in a datable which has mutiple columns StudioX studiox , question	5	430	December 7, 2023
Replace empty cell with 0 using LINQ Help excel , activities , question	22	5822	November 19, 2020

Replace null values with 0 from a data table column using LINQ

Related topics