Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

Block until Done with Union Tool

7 - Meteor



I have 2 outputs getting generated from Join tool which need to be written to the same excel in difference worksheets. When I output them to the same file with different Sheet Names I get the error that the file is being used by another process. 


I unable to use Block until Done as it takes only 1 source. 

How can I achieve this? 


Thanks for your help! 

7 - Meteor

If you have the crew macros installed, there is a tool under there called Wait A Second which should allow you to delay the second output long enough for the first to complete.

Alteryx Certified Partner
Alteryx Certified Partner

Hello @SDeora,


Are you looking for somethig like this?




If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.


7 - Meteor



I hope this solution helps you 


If this post helps you kindly accept it as solution to help other members




12 - Quasar

I would recommend the parallel block until done as a part of the CReW macro pack. This allows for two parallel processes and waits for the first to complete until beginning the second process. This is most useful when trying to write to separate datastreams to the same excel file.