In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Why does my batch macro only run once with no downstream tool after macro?

jt_edin
8 - Asteroid

I'm having a hard time figuring out why my simple batch macro only runs once when it's configured correctly:

 

For example, this should run 10 times but only runs once:

 

macro1.JPG

 

However, when I stick a downstream tool after the macro (any tool seems to work as far as I can see...), in spite of the fact that no macro output is required, then the macro now runs properly, and runs 10 times as intended:

macro2.JPG

 

I'm having a hard time explaining this to colleagues. It seems buggy and inconsistent. Does anyone know what's going on? Thanks

2 REPLIES 2
echuong1
Alteryx Alumni (Retired)

In previous version of Alteryx, you weren't able to click on the anchors of the tools to see the results and you actually needed to use Browse tools to do this. This was solved for the most part with the Browse Everywhere feature, but this did not take into effect for all scenarios, batch macros being one of them.

 

Essentially, the issue is that your macro has an output that isn't going anywhere. As a result, it stops running because it doesn't think the data is needed anywhere else. If you don't have any tools connected to your macro output, it doesn't know how many iterations to run or where to stop. Instead, it just runs a single iteration and returns a single row as a test. If you connect a single tool to the macro output, this is resolved. It can be any tool, it just needs somewhere for the metadata to go.

 

Hope this helps!

jt_edin
8 - Asteroid

Thanks @echuong1 for your speedy and helpful reply.

 

I have a feeling this only impacts batch macros with an output. I have other batch macros with no macro output, which run multiple times just fine.

Labels
Top Solution Authors