In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

How can I Cross Tab This?

FabioP
8 - Asteroid

Dear all,

A have the situation on the left and I need transform to the right:

 

FabioP_0-1652284962104.png

 

I'm not getting it only with the Cross Tab tool...

2 REPLIES 2
binuacs
21 - Polaris

@FabioP @You need add the tile tool then select the unique value method for the field person

 

add a cross tab tool and select Tile_sequence number in the group data and select header as person and pet_name field for the values drop down

 

binuacs_0-1652303399898.png

 

IraWatt
17 - Castor
17 - Castor

Can do it like this:

IraWatt_0-1652285738447.png

Essentially you just need a row number to group on in the cross tab. Any questions make sure to ask :)

HTH,

Ira

Labels
Top Solution Authors