Forum

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
16 - Nebula
16 - Nebula

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
14 - Magnetar
14 - Magnetar

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
16 - Nebula
16 - Nebula

Thank you @Ladarthure, you aced it ! 🙂

Étiquettes