How to swap details

@Kira
You can use invoke code activity and then write the below code

EmployeeDT.AsEnumerable().ToList.foreach(Sub(row)
row(“Gender”)= If((row(“Gender”).tostring = “Male”), “Female”,
If((row(“Gender”).tostring = “Female”), “Male”, “”))
End Sub)

And pass the datatable as an argument
Hope it helps you out

1 Like