We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.
Free Trial

Forum - Français

Trouvez des réponses, posez des questions, et partagez votre expertise d’Alteryx.
TIPS de la semaine

Chaque semaine, découvrez de nouvelles astuces et bonnes pratiques pour devenir un expert !

Voir l'index
RÉSOLU

Output two sheets to the same Excel file problem

Jean-Balteryx
Aurore

Hi everyone !

 

I'm trying to output two tables in two different sheets in the same Excel file.

 

The part of the workflow which does it is as following :

clipboard_image_0.png

 

I get an error telling that the process can not access the file because another process is using it, which makes sense.

I'd like ot use a Block Until Done tool but how to do it in this case ? Or is there another solution ?

 

Thank you for your answers.

 

Jean-Baptiste

2 RÉPONSES 2
Ladarthure
13 - Pulsar
13 - Pulsar

Hi @Jean-Balteryx,

 

a way to do so could be to use the parallel block until done tool from the crew macro pack, you could also do it with regular block until done and a union as in the screenshot

 

Capture.JPG

 

Hope it helped!

Jean-Balteryx
Aurore

Thank you @Ladarthure, you aced it ! 🙂

Étiquettes