Block Until Done won't do my bidding

JFurda

In an effort to retain my sanity, I'm asking for assistance with a workflow. My task is to write user submitted data to a spreadsheet. I want to offer the option of "initializing" the spreadsheet on the first submission and I have the flow working with the exception of a writing order.

My "initialize" (which is essentially loading the Excel spreadsheet, selecting zero records, and saving it) is happening after the user's first submission is saved to the spreadsheet, defeating the purpose of the flow. I cannot for the life of me get a Block Until Done to change the order in which the Output Data tools complete. Any thoughts? (Using the parallel macro isn't an option due to server restrictions)
Block Until Done, why do you hate me?

ScottE

Hi @JFurda 

Block Until Done actually only blocks or holds the data until all the data gets loaded into the tool attached to the #1 output, then it starts releasing the data to the #2 output and so on.  What you need to control your outputs is a Batch Macro.

This link talks about using a batch macro to do what you need. 

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Controlling-the-Order-of-Operations/ta-p/5051

Here is more info on batch macros

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Getting-Started-with-Batch-Macros/ta-p/488165

Hope that helps! 

-Scott