Alteryx Designer Desktop Discussions

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

Iterative Macro does not stop iterating

iegg
5 - Atom

Hi everybody! I'm having a very weird issue:

 

I'm testing the workflows i just moved onto another computer to see if all files are pointing at the right place (both for macros and for output).

Once everything is good to let the computer process the whole dataset, I test a few records to see if it works fine, but the iteration won't stop going on even when all the data is processed.

 

In the picture below you can see that the 9 iterations I wanted were processed and saved into an xlsx file, but then the machine keeps iterating and i cannot explain what's the reason for that (note that this workflow has been used for months and not a single time this weird error occurred). Moreover, I have to stop it manually or it keeps iterating until i don't know, which is strange since once the 9 records are processed the workflow should stop by itself.

 

The error shown below is caused by a multi-row formula, which of course does not work since no data is fed into the process.

output_error.png

 

Do you have any ideas of what's going on and how to fix this? 

 

1 REPLY 1
AkimasaKajitani
17 - Castor
17 - Castor

Hi @iegg ,

 

The stop conditions of Iterative Macro are once the loop output is empty or the maximum number of iterations is reached.

 

If you use the stop condition of once the loop output is empty, I think that you can set the maximum number to solve this problem.
Or it is helpful to watch the output of the loop output. If you want to watch it, you need to add the Iteration Number field by using formula tool with [Engine.IterationNumber] and to connect the Output Data tool before the macro output of the loop output.

Labels
Top Solution Authors