General

Discuss a wide range of topics! Questions about the Alteryx Platform should be directed to the appropriate Product discussion forum.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
SOLVED

Send the iteration number in a variable to a iterative macro

Highlighted
5 - Atom

Hi, please, need help!

I have this iterative macro:

 

pzannier_0-1589428379556.png

 

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.

pzannier_1-1589428711955.png

 

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!!!

12 - Quasar

Hi @pzannier ,

 

Here is how you can achieve it.

 

Main workflow

atcodedog05_0-1589434228002.png

 

Iterative Macro

atcodedog05_1-1589434261511.png

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 : ) 

 

Highlighted
5 - Atom

Thank you very much! I'll try it!

Highlighted
12 - Quasar

Hello @pzannier ,

 

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

 

Thanks : )