Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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

9 REPLIES 9
atcodedog05
21 - Polaris

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
16 - Nebula

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
21 - Polaris

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
21 - Polaris
Timo97
7 - Meteor

hi @atcodedog05,

you saved me again hours of trying.

Thx a lot.

atcodedog05
21 - Polaris

Happy to help : ) @Timo97 

Cheers and have a nice day!

Labels