How to remove Duplicate row Based on "person number" from Two different data table While looping through

[Vincent_Nuestro]

i tried another method Solution from another Topic, but if did not work on me.

it did not delete any row from my data table

How to delete datarow in datatable?

Yah the expression is fine but we cannot use REMOVE DATAROW ACTIVITY inside thr for each row loop as we are currently iterating through each row in the datatable and meanwhile we won’t bale to delete the rows in it and that why Ymir’s was showing that error. So we need to get the row index now using add to collections activity and use a separate for each loop activity and pass the variable used in the add to collections- as input here in for each loop activity and then use remove datarow activi…