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

Learning Hub Academy Feedback
1

Hello!

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?

2

Hi @jsylvan,

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

Regards
Balamurugan.S

3

Thank you!

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

4

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