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.
SOLVED

Output to Multiple Files and Multiple Tabs

fjlorenzo
8 - Asteroid

Can someone help me on how can I create a workflow for this below scenario.

 

I have a master file and I want to output it into multiple files and multiple tabs. My input file has two tabs "Sheet1" and "Sheet2".

 

fjlorenzo_1-1607373139127.png

fjlorenzo_2-1607373197029.png

 

My output should look like this, different files based on country and having two tabs.

fjlorenzo_3-1607373275575.png

fjlorenzo_4-1607373330107.png

 

Thank you for your help

 

 

7 REPLIES 7
Qiu
21 - Polaris
21 - Polaris

@fjlorenzo 
Hope this is what you need.

1208-fjlorenzo.PNG

fjlorenzo
8 - Asteroid

Hi Qiu, thank you so much for your help.

fjlorenzo
8 - Asteroid

Hi @Qiu I tried your workflow but I having this error message

 

fjlorenzo_0-1610679052930.png

 

Qiu
21 - Polaris
21 - Polaris

@fjlorenzo 

The message said the device is not functioning.

Are you outputting the data some remote device? Check the output destination is available or not please.

fjlorenzo
8 - Asteroid

Hi @Qiu the output destination is available. Actually it was able to write the files but on a particular file it stop creating the second sheet and showed that error message.

fjlorenzo
8 - Asteroid

@Qiu I was able to figure it out the error on my workflow. Thank you.

Qiu
21 - Polaris
21 - Polaris

@fjlorenzo 

Glad to know that!😁

Labels
Top Solution Authors