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

Question

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?

use of macro.yxzp

Gaurav_Dhama_ · Answer

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.

use of macro v2.yxzp

Badeagabriela97 · Answer

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

Qiu · Answer

@Badeagabriela97 
You mean Batch Macro?