We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Help adding block to a join output

mwolff604
6 - Meteoroid

I am trying to create multiple tabs in an output file, but due to the complexity of my workflow - I cannot figure out where or how to place the "block until finished" tool. I could not find an answer to my problem out on the community.  Can someone take a look and let me know what I should do?

 

I want 2 excel files for my 7 outputs. The ones in blue work just fine, but the 3 highlighted in yellow return the error "The process cannot access the file because it is being used by another process"

 

 

4 REPLIES 4
AkimasaKajitani
17 - Castor
17 - Castor

Hi, @mwolff604 

 

Put the BlockUntileDone tools before all the output tools.

 

Emil_Kos
17 - Castor
17 - Castor

Hi @mwolff604 

 

@AkimasaKajitani said you need to put block until done just before the output tool that will ensure it will allow you to save to the same excel multiple amounts of times.


Good luck!

 

Emil_Kos_0-1604217981291.png

 

mwolff604
6 - Meteoroid

@AkimasaKajitani & @em I know I need to add a "block until done", but how do you do that on a join output? Did you look at my workflow? Where would you put it in my specific workflow. I am not sure it is possible and I wonder if there is something I need to do differently to make it work?

AkimasaKajitani
17 - Castor
17 - Castor

You have to insert BlockUntilDown tools before all output tools.

 

AkimasaKajitani_0-1604373147593.png

It will work well. Please try it!

Labels
Top Solution Authors