Datatable iteration based on column

Dt.AsEnumerable().where(Function (row) row(“Col_Name”).tostring.Equals(" ")).ToList.ForEach(Sub (row) row(“Col_Name”)=“Value”)

Geeting error as doesnt produce ah value

Hi @Demo_User
If you are storing that query in an data table variable please add .CopyToDataTable at last.

Dt.AsEnumerable().where(Function (row) row(“Col_Name”).tostring.Equals(" ")).ToList.ForEach(Sub (row) row(“Col_Name”)=“Value”).CopyToDataTable

Hope it helps!!

@Demo_User

This needs to be used in invoke code activity and not in assign

Cheerd

How I can remove first three rows from a datatable using linq

@Demo_User

Dt.AsEnumerable.Skip(3).CopyToDatatable

Cheers

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.