Change the Value of Column in DataTable

Hello I want to know how to change the values of columns in Datatable.
My Datatable is like this which is stored in ExtractedDataTable:

And I want to Remove "Rs. " from Salary Column & “Active On:” on Last Activity Column .


1 Like


Use Read Range activity to read the data from excel file and will give you output as DataTable and say ‘datatable’ and then try below LINQ queries.

           DataRow []  newValues = datatable.AsEnumerable().Select(Function(row) row("Salary").ToString.Replace("Rs. ", "")).ToArray

            DataRow []  newValues1 = datatable.AsEnumerable().Select(Function(row) row("Last Activity").ToString.Replace("Active On: ", "")).ToArray
1 Like


I assume you are doing data scraping and getting this datatable, so try to the xaml attached here.

This will check each cell for the required value and replace it and keep that as datatable.
NestedDataTable.xaml (5.7 KB)

Use Read Ranga activity after that for each row