Dynamic title for Excel Tab's

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!

Dynamic Excel Tabs.yxzp

Reporting

Accepted answers

caltang

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/1015093

caltang

More resources here: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Render-to-multiple-tabs-in-1-excel-file/td-p/672096

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

Dynamic Excel Tabs.yxzp

All comments

caltang

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/1015093

caltang

More resources here: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Render-to-multiple-tabs-in-1-excel-file/td-p/672096

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

Dynamic Excel Tabs.yxzp

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!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703