Alteryx Designer Desktop Discussions

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

Transpose rows to columns based on Record ID field

Sudkakani
5 - Atom

Hello Guys,

 

 I am trying to transpose some data from rows to columns based on ID, but getting incorrect results.

 

Input data:

 
 
Record IDNameValue
1Year2000
1CategoryPen
1Customer NameRayn
1ExportGermany
2Year2001
2CategoryPaper
2Customer NameJohn
2ExportUSA

 

 

But the expected output should be like this

Record IDYearCategoryCustomer NameExport
12000PenRaynGermany
22001PaperJohnUSA

 

Attached input file

 

Thanks

SudK

2 REPLIES 2
jasperlch
12 - Quasar

Hi @Sudkakani 

 

I believe what you are looking for is the Cross Tab tool:

Capture.PNG

Sudkakani
5 - Atom

yes and Thanks @

Labels
Top Solution Authors