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