How to Order the Output in excel tab with multiple inputs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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/...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Agreed. But i am not using AMP engine here. Need an alternate for this.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Stacking multiple Block Until Done Tool (alteryx.com) one after another is your option then
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can you show how this can be done with multiple input tools?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks Bro, It worked.