Help adding block to a join output

Question

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"

Alteryx Output Issue.pdf

AkimasaKajitani · Answer

You have to insert BlockUntilDown tools before all output tools.

It will work well. Please try it!

mwolff604 · Answer

@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?

Emil_Kos · Answer

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!