After adding Block Until Done tool, Workflow Fails

[aysha6029]

Hi Friends,

I have 4 workflows streams embedded inside a Single Alteryx Workflow , where the 4 workflow streams write the output to same excel file but different tabs( tab1, tab2, tab3, tab4). I added Block Until Done Tool to Slow down my Workflow so that it write to the same excel file but different tabs without any hassle but even after adding Block Until Done tool in appropriate intervals, my Workflow fails. Please help me to solve this issue.

Regards

Aysha

[pcatterson · Accepted solution]

The 'Block Until Done' doesn't stop one flow from going before another unless it is after the same module.  It only limits the flow to when the last record has arrived at the module.  If they are separate flows, it will not have the desired effect.  The CREW macros has a something called 'Parallel Block until Done' which I think accomplishes what you want to do.

[Ned · Accepted solution]

You need to add a block until done immediately before each output tool and it will work.