How to Output multiple files on same Excel

Community - I'm trying to have multiple parallel processes output to the same excel file on different tabs. In order to let the cache flush each time it's written to, I put in a few "Block Until Done", but it's not working. Here is the flow. Any creative ideas other than setting up separate WFs and running one by one?

Thank you!
Daniele

flow.png

Output

Accepted answers

DataNath

@daniele_zatti try setting up the Control Containers so that only the outputs are in them and staggered, like so:

All comments

ed_hayter

You could potentially use control containers if you are on a current enough version to sequence parts of the workflow so that writing to each sheet of the same excel file can be done

daniele_zatti

Thank you, yes, I have the latest version so I can use this feature. However not sure how I need to set up the containers to actually make it work. See below an example, I still get the error...

DataNath

@daniele_zatti try setting up the Control Containers so that only the outputs are in them and staggered, like so:

daniele_zatti

Thank you both!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703