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
Solved! Go to Solution.
Hi @Timo97
The simplest way is to use 2 output tools and write to each sheets like below.
Workflow:
Hope this helps : )
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!
Hi
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
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
Hope that helps,
Angelos
Thanks a lot guys 🙂
Happy to help : ) @Timo97
Cheers and have a nice day!
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 🙂
Hi @Timo97
Use block until done before output tool
https://help.alteryx.com/20213/designer/block-until-done-tool
Take reference of this post: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Locking-an-excel-file/m-p/824894#M2018...
Hope this helps : )
Happy to help : ) @Timo97
Cheers and have a nice day!