Send the iteration number in a variable to a iterative macro

[pzannier]

Hi, please, need help!

I have this iterative macro:

The condition at red circle is iteration>=1000 so, 1000 is my limit, but I need that value to be a variable, I mean to update that value with the number of records that I have in the workflow where I call the Macro.

I got the max_value, (for example 485) at green circle, so, I need to send that value, to my macro to update the condition.

I tried to use a control parameter, but like my max_value has one row, the macro just iterate once.

Can someone help me?

Thanks!!!

[atcodedog05 · Accepted solution]

Hi @pzannier ,

Here is how you can achieve it.

Main workflow

Iterative Macro

Append limit column and compare it with Engine.IterationNumber (an Alteryx variable created by a iteration macro). Workflow is attached.

Hope this helps

Cheers and Happy Analyzing : ) 

[pzannier]

Thank you very much! I'll try it!

[atcodedog05 · Accepted solution]

Hello @pzannier ,

Please mark my post as "accept solution" if it solves your usecase.

Thanks : )