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