Help to form linq query to for updating every cell in datatable

We have one datatable in which there are multiple columns. We need linq query which checks if the datacolumn is numeric and if yes, it should update some another info in 2nd datatcolumn belonging to the same table.

@RPA24,

Please share sample input and output to help you.

Thanks,
Ashok :slight_smile:

have a look here for update options in general:

lets keep in mind, that using LINQ for Column value updates can result to DataTable reconstructions and/or risk unneded Black Boxing

maybe other options are better fitting instead of LINQ. Also an essential for each row option should not be excluded from the option list as well

Sample Input :- 12345
Output :- '12345

There are around 100 records in excel