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

Data Manipulation - turning column headers into row headers

AboutBlank
6 - Meteoroid

Hello everyone,

 

On paper a simple task but racking my brains - I essentially want to perform the following in Alteryx:

 

Shift the data from:

EntityReserve 1Reserve 2Reserve 3
A702588
B-18609490
C-585562930
D-7003527
E-681760344

 

to

 

EntityReserveAmount
AReserve 17
AReserve 20
AReserve 32588
BReserve 1-18
BReserve 260
BReserve 39490

 

So easy in excel but struggling in Alteryx! All help greatly appreciated.

 

Thank you

3 REPLIES 3
NicholasM
Alteryx Alumni (Retired)

Hey @AboutBlank 

 

This could be done using the Transpose Tool. The Entity would be your Key Column, with Reserve 1 - 3 being Data Columns. 

 

See attached workflow for an example of the tool configuration. 

 

Best,

Nick Michels 

grazitti_sapna
17 - Castor

Hi @AboutBlank,

 

Here is the solution to your problem.

Thanks.

Transpose.png

 

Sapna Gupta
AboutBlank
6 - Meteoroid

Thank you so much for your help! This is spot on.

Labels