Alteryx Designer Desktop Discussions

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

Alteryx Designer: How to output to Excel tabs based on table

SurferJim
7 - Meteor

Hi, I am a newbie and want to be able to filter out data based on Category from table 1 below and then regroup based on table 2 to separate tabs in an Excel output.  Can someone suggest a workflow?  Thank you 🙂

 

Table1

CategoryColumn1Column 2
A12
B34
C56
D78
E910
F1112
G1314

 

Filtering on A, D, and G.  The result is

CategoryColumn1Column 2
A12
D78
G1314

 

Now I want to group A and G as one tab and D as another tab.

 

Tab1Tab2
AD
G 

 

SurferJim_0-1636143585926.png

 

SurferJim_1-1636143607662.png

 

2 REPLIES 2
Tony_Castillo
9 - Comet

I changed the layout of table 2 to the following

Tony_Castillo_1-1636145346248.png

 

This allows us to use the Tab to define the table name in the output tool, as shown below.

Tony_Castillo_0-1636145254382.png

Test file attached.

 

SurferJim
7 - Meteor

This is actually my first post.  You guys are amazing.  Thank you.

Labels