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.
SOLVED

Block until Done with Union Tool

Highlighted
7 - Meteor

Hello,

 

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.

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hello @SDeora,

 

Are you looking for somethig like this?

 

Untitled.png

 

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

Regards

Highlighted
7 - Meteor

Hi 

 

I hope this solution helps you 

 

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

 

Regards,

Sneha 

Highlighted
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.

Labels