Render Table by Group to Individual Excel Sheets NOT Files
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
hellyars
13 - Pulsar
‎02-09-2021
09:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Render issue.
I have to render 374 Excel tables. They currently render to a single sheet. They are grouped by the field [H1] which is essentially the title for each table. Grouping by H1 create the individual tables. Now I want to group the tables by the field [H0] (=Market) and render each Market Group on its own sheet -- not its own workbook. There does not seem to be a simple check this to export by sheet (like there is in the Output Tool). I swear the reporting tools are so frustrating.
Labels:
- Labels:
- Reporting
2 REPLIES 2
Alteryx
‎02-09-2021
10:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @hellyars
You could get multiple tabs on the same file by configuring the layout to be based on "Vertical with section Breaks". See below.
I am also attaching a sample workflow that could help. Cheers!
16 - Nebula
‎02-09-2021
10:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
