Alteryx Designer Desktop Discussions

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

Block Until Done Tool Processing Out of Order

dmpope
8 - Asteroid

Hi everyone,

 

I'm working on a workflow where I need to export 15 different tabs to the same excel workbook. To do this I have 8 different block until done tools to separate the data. However, when I run the workflow, the tools are processing the orders incorrectly. It'll start with the first row, but then start processing the others before that one is done. This causes errors when completing the export saying that Alteryx can't export some tabs.I dragged in all of the tools in the order that I wanted them processed as well (so with the first row, I completed all of the tools after the block until done, then the second row, third, etc). Is there anything that I might be doing wrong here? Below is the screenshot of the workflow mid-run:

 

dmpope_0-1662999625502.png

Error Messages read: "The File Exists (80)" and each time I run the workflow, it's never the same output tools that error.

 

dmpope_1-1662999695397.png

 

Thank you!

 

1 REPLY 1
BrandonB
Alteryx
Alteryx

Have you considered writing each tab to a table tool, bringing them all together with a union tool, and then using a render tool to output the entire file via one tool? This would also allow you to add conditional formatting if desired and avoid the need for a block until done approach because the one Render tool handles it all. If you need multiple tables on one sheet you can take an approach like this: 

 

BrandonB_0-1663005167352.png

 

Labels
Top Solution Authors