Free Trial

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