community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Difficult Transpose Question

Highlighted
Meteoroid

All, 

 

I've been getting comfortable working in alteryx and wanted to thank this community for all its help so far! I had one question about transposing data that I am having quite a bit of difficulty figuring out and could use your help.

 

Essentially I have data about unique 3-letter codes but the data is laid out in rows, not columns. I'd like to group these by the code and then convert the "flights, seats, block minutes, and distance" into additional columns. So the data should go from this:

 

Atx_1.PNG

 

To This:

Atx_2.PNG

 

This seems like a fairly simple transposition, but I can't seem to figure out exactly how to get it to work. Any help you can provide would be greaty appreciated!


Thanks!

@bhushana209

 

you need to use Corss Tab Tool under Transform

PFA sample workflow which does your job

 

Labels