Swap Column Values in a Datatable using LINQ in UiPath
This video will describe how the value in a datatable column can be swapped.
Problem statement : Replace 'Male' Value with 'Female' and 'Female' value with 'Male' in the 'Gender' column in a Employee Datatable.
Run the following query to get the results
EmployeeDT.AsEnumerable().ToList.foreach(Sub(row)
row("Gender")= If((row("Gender").tostring = "Male"), "Female",
If((row("Gender").tostring = "Female"), "Male", ""))
End Sub)
Code Repo : https://github.com/manojbatra071/UiPa...
#rpa #uipath #OneMinuteRPA #uipathrpa #uipathstudio