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.

Render Table by Group to Individual Excel Sheets NOT Files

hellyars
13 - Pulsar

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. 

2 REPLIES 2

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!

 

christine_assaad_0-1612895168057.png

 

afv2688
16 - Nebula
16 - Nebula

Hello @hellyars ,

 

I've set up a little example here.

 

Regards

Labels
Top Solution Authors