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. 

Is it a way that I can achieve this, please?

[abacon]

@Badeagabriela97 It is definitely possible.

Are you able to post the macro with dummy data? I see you have a filter on your data that I assume isn't getting the desired result making it hard to troubleshoot your problem without seeing the actual macro.

Bacon

[Badeagabriela97]

Here it is. Please help. The idea is that I don't want to have duplicates in macro's output, so it needs that each iteration checks only the data filtered from the last one.

[Badeagabriela97]

What I want:

Columns in data: 

1st iteration:

2nd iteration:

Now the output of macro gives doubled entries:

[abacon]

@Badeagabriela97 Did you mean to build an iterative macro or a batch macro? Using control parameters make it a batch macro, meaning it will run over the entire dataset for each record fed into the control parameter.

Bacon

[abacon]

@Badeagabriela97 Additionally, it is not very clear what you are trying to accomplish with this workflow.

However, the reason the macro is doubling records is because it's a batch macro and not an iterative macro. Meaning for each record fed into the control parameter (in this case 3 records), the macro will run. It is not a iterating through the data and ending when a condition is met.

Bacon

[Badeagabriela97]

But how can I transform it in an iterative macro that runs for each column of the file, please?

[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.