Batch Macro not looping after running the workflow as an analytic app

Vernon

I have a workflow that calls a batch macro to run through multiple store locations and exports an excel file with a sheet for each store (The sheet name is also controlled by the control paramter that is being fed in).

This works absolutely fine while running as a normal.

I decided to design it as an analytic app instead of a workflow, so that users can change the files (different months of the year) being fed in to generate the excel file.

Once I did that, the macro batch does not loop anymore.

The message I got from the App Results was "1 iterations were run (ended by a downstream tool)"

I did search up this error, it seems that users are missing a browse button in the workflow / output button in the macro. However, I have both buttons in my workflow.

If I switch back to running it as a workflow, it will work fine and generate an excel file with multiple tabs.

Wondering if anybody encountered this problem before or am I missing a setting so that it doesn't loop at all.

Thanks!

1 Workflow Analytic App.jpg

2 Macro.jpg

3 Macro result run by Analytic App.jpg

4 Macro Result run by Workflow.jpg

Claje

Hi,

I'm making an assumption that the actions are all configured properly here.

I think the issue is that your macro has an output that isn't going anywhere.  As such, it stops running because it doesn't think the data is needed anywhere else.

If you try removing the Macro Output, what happens?