The batch macro in workflow runs multiple iterations in Designer but only runs once in Gallery even though there are multiple records in the data.
- Alteryx Designer
- Batch Macro
If there is a Macro Output in the batch macro, the output anchor of the batch macro must be connected to a tool.
The reason why this works in Designer is that the Browse Everywhere feature is enabled in Designer by default. If you click on the output anchor of your batch macro after you run, you will see the output in Designer. With this feature enabled, it will write out the output for each iteration to a YXBE file stored in the temporary folder without having to connect to a tool. However, in Gallery this "Browse Everywhere" feature is disabled. Hence, it will stop at one iteration since it cannot output the data.
If you disable the browse tools in the Workflow - Configuration > Runtime, you will find that the workflow in Designer runs only once.
Always connect the output anchor of the batch macro to a tool in the workflow. If the output is not necessary, remove the Macro Output in the batch maro.