Hi @glombard ,
You're on the right track using Block Until Done, but you need to create a link between the different streams to get the desired behaviour*.
A technique I often use is to:
1) From the 2 or 3 output of your first Block Until Done add a Summarize tool
2) In Summarize calculate the count of any field (or any other operation that will only generate ONE record)
3) Append this single record to your second stream and make sure the appended field is NOT selected (this means you are basically appending nothing)
4) Repeat as needed
You can see this in the below screenshot:
* technically a set of unlinked Block Until Done tools can be used to control the output order (they will execute in order based on the Tool ID) but I don't generally recommend this approach
Hi @glombard ,
I've made some changes to your workflow that should ensure it writes out the sheets in the correct order.
You had a few too many Block Until Done tools. You only need one before each output in each stream (most of your streams had two).
I've also attached a simpler workflow that demonstrates the concept on a smaller scale. In the context of your workflow, here's a screenshot showing how this translates:
Let me know how you get on with this.
Jamie
