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

[SurferJim]

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

Category	Column1	Column 2
A	1	2
B	3	4
C	5	6
D	7	8
E	9	10
F	11	12
G	13	14

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

Category	Column1	Column 2
A	1	2
D	7	8
G	13	14

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

Tab1	Tab2
A	D
G

[Tony_Castillo · Accepted solution]

I changed the layout of table 2 to the following

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

Test file attached.

[SurferJim]

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