We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Excel Output File

Daleowski
5 - Atom

I have my workflow filtered down to 3 specific criteria. I want one excel file with 3 tabs for the filtered data. If I could name the tabs before opening the file that would be great too. Tabs are PE, CIO, and Other.

3 REPLIES 3
alexnajm
18 - Pollux
18 - Pollux

I'm not sure what the question is - are you asking to output to different tabs of the same file? Then sure, use Control Containers - Use Case #1 is your exact use case: Control Containers: Take Control of Your Workflow - Alteryx Community

Daleowski
5 - Atom

I was able to get all of my outputs into one excel file on separate tabs by simply using the same file path but naming each sheet different. You have to select the option "Overwrite Sheet or Range" in Output Options within the Configuration panel.

stevemarkovick
7 - Meteor

I had a similar situation recently where I needed multiple filtered outputs into a single Excel file with separate tabs, and it wasn’t immediately obvious how best to do it. Using the same file path with different sheet names, combined with the "Overwrite Sheet or Range" setting, is definitely a clean solution. Also, thanks for mentioning Control Containers — that opens up even more possibilities for structuring the workflow neatly.

Labels
Top Solution Authors