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.

Multiple Tables in a single worksheet, each table based on criteria

bobbybalan
7 - Meteor

Hello, I have the below dataset. How can I create two separate Tables for each Category (Cat A and Cat B) in a single worksheet? The columns in each Table will be Month 1, 2 and rows will be Item1, Item2, Item 3. I am attaching the output here. Thanks so much in advance!

 

Category  Month    Items    Dollar

Cat A        1            Item 1    100
Cat A        1            Item 2    200
Cat A        1            Item 3    300
Cat A        2            Item 1      10
Cat A        2            Item 2      20
Cat A        2            Item 3      30
Cat B        1            Item 1      60
Cat B        1            Item 2      70
Cat B        1            Item 3      80
Cat B        2            Item 1        1
Cat B        2            Item 2        2
Cat B        2            Item 3        3

2 REPLIES 2
FláviaB
Alteryx Community Team
Alteryx Community Team

Hello, @bobbybalan. I am moving your post to our Designer Discussions board for more visibility. 

Flávia Brancato
Christina_H
14 - Magnetar

I've had a go at this two different ways, see which works better for you.  One creates the tables for a normal output tool and will export without formatting.  The other uses reporting tools so you can include formatting.

Labels