Exploring Iterative Macros

[davidcolunga]

Hi all,

Fairly new to Alteryx and built my first iterative macro! However, it's stopping after five iterations (I'm expecting 100) and completely dropping the rest of my records. Any idea on how to fix it? Thanks!  

[alexnajm]

Congrats on your first iterative macro! Have you set the number of iterations to be more than 5 in the Interface Designer Property settings?

Otherwise, we won't be able to help much further without knowing the macro and the data

[cpet13 · Accepted solution]

@davidcolunga this article explains about iterative macros Iterative Macro (alteryx.com). It sounds like it may be what you have set for the Maximum Number of Iterations option and the When Maximum Number of Iterations Is Hit. What do you have set for those?

[davidcolunga]

Thanks for your help all! Going through my workflow again, there was a join in my macro that was erroring out due to matching based on a number. Fixed that error and the macro worked perfectly!