In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Transposing Columns

dhakim1996
8 - Asteroid

Hi,

 

Does anyone know how to convert the following table:

NameCat 1Cat 2Cat 3Cat 4
A1234
B5678

 

into this:

NameCatAmount
ACat 11
ACat 22
ACat 33
ACat 44
BCat 15
BCat 26
BCat 37
BCat 48

 

Thank you in advance!

2 REPLIES 2
DataNath
17 - Castor
17 - Castor

@dhakim1996 if you use a transpose tool and select Name as a Key Column that should do the trick. By default, Alteryx will name your transposed fields as ‘Name’ and ‘Value’ - as you already have a ‘Name’ column this second one will become ‘Name2’ and so you’ll need to use a Select tool or something afterwards to rename your columns as you wish.

 

Transpose like so:

 

DataNath_0-1663655906938.png

 

Select after for rename:

 

DataNath_1-1663655946976.png

binuacs
21 - Polaris

@dhakim1996 as @DataNath mentioned you need to use the transpose tool to get the desired result

 

binuacs_0-1663653955227.png

 

Labels
Top Solution Authors