Alteryx Designer Desktop Discussions

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

How to Order the Output in excel tab with multiple inputs

Sattysats77
6 - Meteoroid

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?

6 REPLIES 6
alexnajm
17 - Castor
17 - Castor

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
6 - Meteoroid

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

alexnajm
17 - Castor
17 - Castor

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

Sattysats77
6 - Meteoroid

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

alexnajm
17 - Castor
17 - Castor

Block Until Done.png

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
6 - Meteoroid

Thanks Bro, It worked.

Labels
Top Solution Authors