SOLVED
How to output tables to different excel tabs
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
craigja
10 - Fireball
‎01-05-2024
06:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Solved! Go to Solution.
Labels:
- Labels:
- Reporting
2 REPLIES 2
‎01-05-2024
06:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I can get it to nearly work but is there a way to specify the tab names based on a field?
17 - Castor
‎01-05-2024
06:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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...
