We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Batch Macro that does not Union at the output

Dave
5 - Atom

Is it at all possible to create a batch Macro that does not union at the output tools?  I am trying to build a process integrated with SQL server that, for each record at a time from input tool, use download tool for API calls, write the results to SQL temp tables, then execute a stored procedure against those temp tables.  This would be more like a true function, or a do for each, where there is no union being done.  At the moment I cannot figure out how to just run the macro one at a time unless I literally limit one record per run and then schedule or manually run the workflow x times.

 

I can, if needed, rewrite the stored procedures to expect batches in the temp tables, but I am really hoping this can be handled in the Macro configuration.  Any help is greatly appreciated.

1 REPLY 1
Dave
5 - Atom

I figured this out, created my own problems.  This only happens during runs of the macro by itself in testing, once chained to another workflow it does in fact run "one at a time".  Hopefully this saves someone else some head against desk banging.

Labels
Top Solution Authors