Multiple Input into 1 Excel book with multiple output sheets in the same workbook

[Ben_Kohler]

Unsure if this has already been covered. Attempting to pull 4 different query results into 1 workbook but each query needs to have it's own tab. Currently this is what my workflow looks like. The problem i run into is that it believes the file is open simultaneously by the others - is there a tool that may help me run each query in sequence? I attempted the block until done tool, but didn't have much luck. 

[bbak91]

Block until done completes everything coming out of the first output before starting on the second output. The added complexity comes from the fact that you have effectively separate streams in your workflow. The approach that I took "links" these streams together which is how we can control execution order.

[Ben_Kohler]

Thanks for the visual! Definitely going to try this out! I'll circle back and mark it as a solution or let you know if I have further problems!

Appreciate the help !

[Ben_Kohler]

Hi Brandon,

I've recreated the workflow that was shared, but I am curious why I am having issues still. When running it. It appears to be starting with the 2nd file instead of the first file. Is there a way to manually tell the alteryx workflow to start with said file and then the next and so on? I've deleted all 4 of the inputs and rebuilt them and it still seems to want to start with the second input data icon.

[bbak91]

The actual loading of data from the input data tools is optimized behind the scenes with the Alteryx Engine. Even though the data is read in from your sources in a different order than you want, the execution of the downstream tools should be controlled with the block until done tools. 

[Ben_Kohler]

Ok, that makes sense. My co-worker and I are going to play around with the placement. So far it's definitely a solid solution. I'll let you know the final outcome/if i have any further questions.

Thanks again!