Iterative Macro - part of data not to loop back in next iteration

[Badeagabriela97]

Hi,

I want to build an Iterative macro so I can repeat a filtering process.

At each iteration I group data by each column of file and where sum of Amount is null I map with Yes/No on a Net-off column.

My problem is I want part of data with flag of "Yes" on Net-off column to filter out at each iteration and not to loop back at the next iteration. 

What I want:

Columns in data: 

1st iteration:

2nd iteration:

Now the output of macro gives doubled entries:

Is it a way that I can achieve this, please? Maybe combine a match macro with an iterative one?

[Qiu]

@Badeagabriela97 
You mean Batch Macro?

[Badeagabriela97]

Yes, I know, but I want a solution, please, maybe a combination of another batch macro and this transformed in a real iterative macro.

[Gaurav_Dhama_]

Here you go, I changed the approach completely.

Removed the batch macro and just used Iterative macro. I tested it with few scenarios, and it worked. Check it out.

Mark it as solution if this solved your problem.