Dynamic title for Excel Tab's

[Charity_K_Wilson]

I have a report I've created, and I need to create dynamic names for the Excel Spreadsheets.

One group is based on where the Employee works.  I need the tab's to reflect the city the employee is located in.

Another group is based on the Team the Employee reports up to.  But I can't seem to figure out how to associate the data to the tab.  I've got the field labeled as "tab", something  @PuffinPanic recommended.  But it was late on a Friday so I may have misunderstood her!

[caltang · Accepted solution]

This is a good starting point to explore: https://community.alteryx.com/t5/Engine-Works/How-to-Render-to-Multiple-Named-Excel-Sheets/ba-p/1015... 

[caltang · Accepted solution]

More resources here: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Render-to-multiple-tabs-in-1-e...

I've done one for you here for Location only:

[PuffinPanic]

Thanks for following up on this @caltang  . I definitely missed out some steps (it was late and had been a long week!) when I mentioned adding a 'tabs' field.

Like the essential bit about section breaks - you then get an option to select a field for the name of the sections. 

Sorry for confusing you @Charity_K_Wilson 

[caltang]

Got your back!

[Charity_K_Wilson]

Thank you! @caltang .  I was searching Community for those articles yesterday.  I knew I had seen them.  

Really appreciate the assist!