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

Transpose like excel functionality

Shank
8 - Asteroid

Hi All,

 

I need to transpose data similarly to excel can some one help on this.

 

Many thanks for your help

 

Input

 

NameYearStdV1V2
A2018NORMYesYes
B2018NORMYesYes
C2018NORMYesYes
D2018NORMYesYes
E2018NORMYesYes
F2018NORMYesYes

 

Desired Output

 

NameABCDEF
Year201820182018201820182018
StdNORMNORMNORMNORMNORMNORM
V1YesYesYesYesYesYes
V2YesYesYesYesYesYes
6 REPLIES 6
BenMoss
ACE Emeritus
ACE Emeritus
You can so this in two steps with Alteryx.

First transpose your data. Your name field will be your key field and everything else should act as a data field.

This will give you three fields. Name, Name2 and Value.

Next, use the cross tab tool.

Name2 will be your group by field, Name will be your headers field and Value will be your value field.

Give this a try and let us need further help or if it brings you to a solution.

Ben
haroon_sa
10 - Fireball

Hey @Shank

 

Check out this solution. Hope it helps.

 

tr1.PNG

Present_guy
8 - Asteroid

A development possibility...... add a single tool or parameter for "Excel transpose"? Students find it frustrating to have a transpose tool that is unlike their familiar transpose tool.  

flying008
14 - Magnetar

Hi, @Present_guy 

 

Just like your need function in gallery.

 

录制_2022_06_18_08_11_28_338.gif

 

Present_guy
8 - Asteroid

Thanks - can you please provide a url? I searched for and couldn't find this. And interestingly, there are MANY posts about this issue in the discussions and several very helpful work--around solutions. 

flying008
14 - Magnetar

Hi, @Present_guy 

 

here you are.

 

https://community.alteryx.com/t5/Public-Community-Gallery/Transpose-Excel-style/ta-p/904150

 

Labels