How to either remove or add a row from/to DataTable


I use a for each loop to check through every row in my DataTable. Depending on an if statement I would like to either remove this row from the DataTable or add this row to a new DataTable (that I can process later).

I have tried to remove the rows but that it’s not possible to do inside a for each loop, I also tried to add the row to a new DataTable but it can not be done because of it already in another DataTable (the original one).

Did anyone get any ideas on how to counter this issue?

Hi @jsylvan,

Using the Add Data Row Range and Remove Data Row Select you can able to add or remove list of the datarow.


Thank you!

But is it not possible to do this without importing your workaround?

For others who got this problem I could also solve it by Invoke Method.