How to update column's value in datatable with LINQ?

Help Studio
, ,
18

Hi,

Can you try the following expression using Assign activity?

dt = dt.AsEnumerable.Select(Function(r) dt.Clone.LoadDataRow({r(0),r(1).ToString.Replace(",","、"),r(2),r(3),r(4),r(5),r(6)},False)).CopyToDataTable()

Please replace index number to column name for readability, if the above works.

Regards,

2 Likes