Alteryx Designer Desktop Discussions

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

Crosstab feature with Multiple Columns

Jacob_Kist
5 - Atom

I am fairly new to Alteryx and looking to solve for a problem using crosstab, but running into some issues. 

 

Current Data

AccountColumn LabelColumn IndexValue
1234Frist Name1John
1234Last Name2Doe
1234First Name3Jane
1234Last Name4Dane
1235Last Name5John
1235First Name6Dane

 

What I am looking for in the output is:

 

AccountFirst NameLast Name
1234JohnDoe
1234JaneDane
1235JohnDane

 

I Thing cross tab is the right operation to use, but I'm

1 REPLY 1
binuacs
20 - Arcturus

@Jacob_Kist One way of doing this

binuacs_0-1676921010344.png

 

Labels