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