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

creating multiple Excel spreadsheets

Timo97
7 - Meteor

Hello everybody,

i have a small question i would like to create one excel file as an output, with multiple inputs and each input goes on an different sheet.

Sound not so hard but cant find the way to create it.

 

Would be nice if someone could help thx.

 

LG Timo

10 REPLIES 10
atcodedog05
22 - Nova
22 - Nova

Hi @Timo97 

 

The simplest way is to use 2 output tools and write to each sheets like below.

 

Workflow:

atcodedog05_0-1632214422335.png

 

Hope this helps : )

 

Emil_Kos
17 - Castor
17 - Castor

Hi @Timo97,

 

I would strongly advise checking this article: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Output-to-multiple-sheets-within-an...


It covers this topic really well and I am sure you will enjoy it!

AngelosPachis
16 - Nebula

Hi 

@Timo97 

 

To create multiple sheets in a single excel spreadsheet you first need to have a column with the different tab names. Then in the output tool, you can select to take the table name from that particular column

 

AngelosPachis_0-1632214465059.png

 

To find different ways of how to configure the tool, I suggest you have a look at the sample workflows (right-click on the Output tool, select Open example) or read through the help page here

 

AngelosPachis_1-1632214559379.png

 

Hope that helps,

Angelos

 

Timo97
7 - Meteor

Thanks a lot guys 🙂 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Timo97 

Cheers and have a nice day!

Timo97
7 - Meteor

Hi @atcodedog05,

i did exacly what you advised, and it is working with 10 out of 11 outputs but the 11 output is saying ERROR:" Unable to open file for write: C:\Users\t......"


Do you have any idea why this is popping up? 

 

Thanks already for your help 🙂 

atcodedog05
22 - Nova
22 - Nova
Timo97
7 - Meteor

hi @atcodedog05,

you saved me again hours of trying.

Thx a lot.

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Timo97 

Cheers and have a nice day!

Labels