Hi Shilpa_Mohanty,
Have you solved your case or not yet?
In case you haven’t I will suggest to use the expression mentioned is my post referred in here:
Create an invoke code with one argument in/out named InitialDT and as value give your table containing the values (83 columns)
InitialDT.AsEnumerable.Where(Function (c) c(“<Name of the column>”).Equals(“”)).Select(Function(c)
c(“<Name of the column>”)=“0”
Return c
End Function).ToList()
Replace the “<Name of the column>” with your column name (the one you would like to replace the values)
Replace - Equals(“”) with Equals(“-241”)
if the column is of other type than string you can add the .ToString like this:
InitialDT.AsEnumerable.Where(Function (c) c(“<Name of the column>”).ToString.Equals(“”)).Select(Function(c)
c(“<Name of the column>”)=“0”
Return c
End Function).ToList()
Copy the invoke 3 times and change the mane of the column.
Let me know if worked.
Regards.