Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Output multiple workflows into 1 excel file under different sheets

JingYih_Herbalife
8 - Asteroid

I have multiple work flows created and would like to transfer all the workflows into 1 excel file but in different sheets. 

Appreciate the help on which tool is best suited for this.

 

Thanks and regards,

Jing Yih

4 REPLIES 4
FinnCharlton
13 - Pulsar

Hi @JingYih_Herbalife ,

 

You can choose to 'Overwrite Sheet or Range' in the Output Data tool. You can then specify the name of the sheet within the workbook, and the data will be added to that sheet:

FinnCharlton_1-1683277491302.png

 

FinnCharlton_0-1683277470269.png

Hope this helps!

jemns41581
5 - Atom

One option to output a file to multiple sheets or tabs within an Excel file is using the Output tool. In this example, we want to create multiple sheets or tabs. We’ll have one tab per city so that all of the customers in the same city will be in the same sheet or tab.

jemns41581
5 - Atom

Did anyone get a suggestion? My Insurance Info

JingYih_Herbalife
8 - Asteroid

@jemns41581 the recommendation from @FinnCharlton works for me. 

Labels
Top Solution Authors