Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Multi-Filter Output differents excel tabs

david20100
8 - Asteroid

I want my output to be filter in differents categories and output to the same excel sheet but a tab by categorie. (see attach)  It is possible?  For the moment i have errors the file is already open when others output wants to write their datas.

 

thanks

 

multi-output.JPG

2 REPLIES 2
pcatterson
11 - Bolide

You can accomplish this in the output tool:

 

Sheets.png

 

Also see the attached workflow.

Hugo
9 - Comet

Hi David, 

 

Check out the "block until done" tool in the developer tab - you could place several after your central select tool. This blocks output to the second branch until the first has completely finished running, allowing the excel file to finish being written to before you try to write to it again for a different tab.

 

Alternatively, if you have the CREW macros installed, you could use the parallel block until done tool, which is similar.

 

Hugo

Labels