Alteryx Designer Desktop Discussions

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

Transpose multiple fields

Luca
8 - Asteroid

Hi All, 

 

I need to transpose the information in this table as per attached example.

Unfortunately, my attempts keep failing!

 

Thank you in advance. 

 

  INPUT           OUTPUT     
                     
OrderCodeIDNameCountry  OrderAGName AGENName ENREName RERGName RGWEName WEZBName ZBCountry
143450666AG1448828Name1GB  1434506661448828Name11448828Name11453271Name1.21448828Name184020623Name184020623Name1GB
143450666EN1448828Name1GB  1434510611432111Name21432111Name21432111Name21432111Name284003347Name284003347Name2DE
143450666RE1453271Name1.2GB  1434702871468689Name31468689Name31468689Name31468689Name384075788Name384075788Name3FR
143450666RG1448828Name1GB                
143450666WE84020623Name1GB                
143450666ZB84020623Name1GB                
143451061AG1432111Name2DE                
143451061EN1432111Name2DE                
143451061RE1432111Name2DE                
143451061RG1432111Name2DE                
143451061WE84003347Name2DE                
143451061ZB84003347Name2DE                
143470287AG1468689Name3FR                
143470287EN1468689Name3FR                
143470287RE1468689Name3FR                
143470287RG1468689Name3FR                
143470287WE84075788Name3FR                
143470287ZB84075788Name3FR                
2 REPLIES 2
LordNeilLord
15 - Aurora

Hey @Luca

 

You need to do a double crosstab:

 

Double CT.PNG

Luca
8 - Asteroid

Thanks @LordNeilLord!

 

Eventually I reached the same solution. Good to see that I got it right!

Labels