community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More

Transform the table

Asteroid

Hi everyone! I need to transform this table in that way. I've managed to build a pivot ID-Concert, but don't have any idea how to add there type1 and type2. So thanks for any idea!

 

IDConcertType1Type2

Id1

AvroraBalletModern
Id1Sleeping Beauty OperaModern
Id2AmoreOperaClassic
Id3AmoreOperaClassic
Id3AvroraBalletModern

 

 ModernModernClassic
 BalletOperaOpera
 AvroraSleeping beautyAmore
Id111 
Id2  1
Id31 1
Bolide

Hello @Nastya,

 

I've been able to create the pivoted version of what you're trying to achieve. I'm not sure Alteryx supports multiple column headers in the way you're trying to present the data.

 

Using my method, however, you should be able to then transpose the output table in software such as MS Excel to reach your desired outcome. Not ideal, I know but I'm unaware of another option.

 

Capture.PNG

 

Sam :)

Labels