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.
SOLVED

How to Turn Rows in One Column Into Field Headers.

TwanD
7 - Meteor

Hi everyone,

 

I'm trying to turn all my rows under F1 column into headers and having a hard time figuring out how to do so.

 

Original Data:

 

F1                             F2             F3               F4

Tax Owner               O1             O1              O2

Tax Code                 001            001             002

Entity Name             A                B                C

 

I want it to look like this:

 

Tax Owner              Tax Code             Entity Name

O1                           001                       A

O1                           001                       B

O2                           002                       C

 

I tried transposing and that doesn't seem to work. Any help would be greatly appreciated, thanks!

11 REPLIES 11
Kenda
16 - Nebula
16 - Nebula

Hey @TwanD! The key here is to Transpose your data and then Cross Tab it. With your Transpose, you will want F1 to be your key field and the rest Data Fields. After that, in your Cross Tab tool, Group By the Name field and then set F1 as the new headers and the Value field as the values for new columns. You can then use a Select to rearrange and get rid of the Name field. Hope this helps!

 

transposecrosstab.PNG

TwanD
7 - Meteor

Thank you so much, I had tried to crosstab after transposing as well but what I didn't do was checking the Name to be grouped for Value so then it wasn't crosstab correctly. Thanks again, greatly appreciate your help because it was driving me a bit nuts lol.

Kenda
16 - Nebula
16 - Nebula

@TwanD No problem, glad to help! Things like this just come with experience. I remember the first time someone else showed me this trick to solve a similar problem I was having. 

Daniel_Aguirre
5 - Atom

Thanks @Kenda  

Adhiti
5 - Atom

Thank you so much for this answer ,i was stuck with a similar issue for 2 hours 😞 and your answer helped. But i am still trying to understand the logic for how  cross tab and transpose work.

Kenda
16 - Nebula
16 - Nebula
sgwong
8 - Asteroid

After the result above result, seek advice on how to merge into single row as per attach.

ljpanetta
7 - Meteor

I'm somewhat new to this forum, so I apologize if this should be a separate question versus being tagged to this current thread. I am trying to convert the following rows to columns, but can't quite figure it out with the Transpose & Cross Tab functions. Any help would be appreciated.

 

ljpanetta_0-1645820635860.png

 

flying008
14 - Magnetar

@ljpanetta 

 

Hi, pls see the pic, you only need corss tab !

cc.png

Labels