Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Output Excel worksheets into the same workbook by unique grouping.

Jesse89
7 - Meteor

Hi all,

 

I've been having a problem where I need to report my data in groups and break out the report into multiple worksheets.  For example, if I have a city column, I normally use a filter tool to filter out records that only contain that city and then send the output to an output tool.  However, my dataset is much larger and I'm looking at using 20+ filter tools with 20+ output tools to achieve this task.

 

I'd like to create a way to output data based on the data in a specific field.  So I my idea is to using a macro (which I have limited exposure to and unsure which type to use), and use the following tools to achieve this task: Tile Tool (using unique), Dynamic Rename, Filter and Output Tool.   I think I can use the tile tool outside of the macro, feed in the tiled data and filter by the unique tile group using the dynamic rename to change the filter and sheet name.  How to set this up and make it work properly is what I need help with, or if there is another tool that does this like a Dynamic Output Tool.

 

Please see the attached dummy data, and thank you guys so much for all your input!

 

Jesse

3 REPLIES 3
BenMoss
ACE Emeritus
ACE Emeritus

No need for filters or a macro or anything like that, this is available straight out of the box with a single output tool.

 

Check out the options available at the bottom of the output data tool when you select xlsx workbook.

Here you can 'change file/table name from field'.

 

Check this box and you will then have the ability too add a suffix/prefix change entire name (with an excel file this means to the sheet). You then choose the field you want to cut your data by, say city, and then whether you want to keep the field in the output.

When you hit run alteryx will generate n number of sheets based on the number of cities that exist in your data.

 

Ben

BenMoss
ACE Emeritus
ACE Emeritus

Example attached.

 

Ben

Jesse89
7 - Meteor

Thank you Ben!

 

This saved me a lot of time.

 

Jesse

Labels