Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Iterative macro continues to loop even with 0 records

patrickprentice
8 - Asteroid

Exactly what the title says.  I've built a macro to pull in some data from an API we're using and it's working perfectly except for the fact that it continues to loop even after the iterative output hits 0 records. 

 

IVR Macro.png

In my testing container up there it's testing to see if the latest record being pulled has a date equal to the last record in an excel file it's reading from.  If it isn't the same date it drops the date range by one day for the next API call and does it again until it reaches the last date.  It works perfectly and when the date in the API call is equal to the date in the file nothing comes through on the false side of that first filter.

 

Annotation 2023-02-27 114143.png

 

For some reason, however, when I plug it into my workflow it just continues to iterate up through my iteration limit.  I'm assuming I'm missing something super obvious here.  Can anyone chime in and save me from pounding my head against my desk for the rest of the day?

1 REPLY 1
patrickprentice
8 - Asteroid

Solved, I guess.  This only occurs if I have the "When Maximum Number of Iterations is Hit" option in the interface designer to "Error".  If I change it to "Warn" then it doesn't keep on iterating.

Labels
Top Solution Authors