Something that my teams have always enjoyed doing in the past is trying to remove a datatable row based on an list of values, but this has always been tricky as you can’t remove the datarow whilst iterating through the datatable. However, today I found a neat way of doing this…
Read in your list of values to check in the datatable - e.g. list of unique reference numbers URNs
Create a for each loop to loop through your newly read list of URNS (either datatable, or list doesn’t really matter)
Use the Lookup Data Table activity to lookup the URN in the matching column in the datable and return the row index.
Now you have the row Index simply grab a remove row activity and use that row Index to delete the row. Because you are looping through the list of URNs and not the target datatable, you are able to remove this row with no issues.
Maybe not the most resource effective way to do this, but by far the simplest.
Hope this helps.