In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

How to output tables to different excel tabs

craigja
10 - Fireball

I am created tables, and each table has a month name, so:

January Table1

February Table2

etc

 

I want to create 1 excel file with these tables as separate tabs, I'm using the reporting Table tool to create these since I want to use row formatting to highlight anomalies, I cant figure out how to do this!

2 REPLIES 2
craigja
10 - Fireball

I can get it to nearly work but is there a way to specify the tab names based on a field?

DataNath
17 - Castor
17 - Castor

Hey @craigja - I wrote up a blog on this a while ago which outlines the steps needed to achieve this. You can find it here: https://community.alteryx.com/t5/Engine-Works/How-to-Render-to-Multiple-Named-Excel-Sheets/ba-p/1015...

Labels
Top Solution Authors