How to Order the Output in excel tab with multiple inputs

[Sattysats77]

Hi All, I have 10 input tools each has unique SQL query written to pull the data. I would like to write those in each tab in excel with an order.  Can someone suggest how this can be done?

[alexnajm]

Control Containers are your best bet to ensure one part finishes before another kicks off! https://community.alteryx.com/t5/Engine-Works/Control-Containers-Take-Control-of-Your-Workflow/ba-p/...

[Sattysats77]

Agreed. But i am not using AMP engine here. Need an alternate for this.

[alexnajm]

Stacking multiple Block Until Done Tool (alteryx.com) one after another is your option then 

[Sattysats77]

Can you show how this can be done with multiple input tools?

[alexnajm · Accepted solution]

There you go with the Parallel Block Until Done tools from the CreW macros: Chaos Reigns Within: Alteryx CReW Macros. You could build similarly if needed with the regular ones if you look at the inner workings of the macro.

However, I do suggest Control Containers instead of this - if you are concerned about the engine being too different then Engine compatibility Mode is a setting you can turn on right under AMP Engine

[Sattysats77]

Thanks Bro, It worked.