Block until Done with Union Tool

[SDeora]

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! 

[Lbunce]

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.

[afv2688 · Accepted solution]

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.

Regards

[sneha_bhiwagade1]

Hi 

I hope this solution helps you 

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

Regards,

Sneha 

[neilgallen]

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.