Block until Done with Union Tool

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!

Output

Join

Accepted answers

afv2688

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

sheetnames1.yxmd

All comments

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

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

sheetnames1.yxmd

sneha_bhiwagade1

I hope this solution helps you

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

Regards,

Sneha

AlteryxOP.yxmd

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.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335