Delete excel row based on if condition

Help Studio
,
1

Hi there! I’m using an excel for each row activity, and I need to delete or ‘ignore’ the rows from the spreadsheet that in the column P, or “Status”, are equals to “Arquivado”. How can I do this? Thanks! :smiley:

2
  1. Inititalize one counter = 0 before the start of for loop.
  2. In the for loop check the condition and if it matches then use “Remove Data Row”
  3. In the properties , you will find index , pass the counter variable as index.
  4. Increase the counter = counter +1
3

Just put an If around the Delete Rows activity.

4

If you want to skip the row, the following works.

image
image623×749 19 KB

If you want to remove rows, the following will work.

image
image856×1879 51.9 KB

Sample20230822-1L.zip (9.1 KB)

Regards,

5

Why not just use the Delete Rows activity inside the loop?

6

Hi,

Can you check the following message? To make sure, it’s better to be used outside ForEachRow loop, I think.

image
image810×189 10.9 KB

Regards,

7

Maybe you can use Filter Data Table activity instead of using For Each Row?

image
image819×231 14.3 KB

I wouldn’t necessary advise using For Each when you are dealing hundred of thousands of data rows, it has longer processing time.

8

Ahhhh I hadn’t tried it so I didn’t know that. Thanks!

9

Basically when deleting a row in a for loop you will miss the index. In short the input datatable cannot both be iterated and modified in the same for loop.

@ton I agree, Filter Datatable is an elegant way of solving this issue.

10

I tried the first way to ignore it! Lets see if it works! Thank you sm! :smiley: