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

Alteryx designer Discussions

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

create table with two columns headers

Meteor

I have a data which looks something like this.

IDTitleSubjectValueChapterWeight-age
100ScoresMaths30130
100ScoresMaths30230
100ScoresMaths30340
100ScoresEnglish20150
100ScoresEnglish20250
100ScoresChem25125
100ScoresChem25235
100ScoresChem25340
100ScoresPhysics25150
100ScoresPhysics25250

 

I would need to transform my data to cross tab to two columns as headers (Subject & Value)

   MathsEnglishChemPhysics
   30202525
IDTitleChapter    
100Scores130502550
100Scores230503550
100Scores340 40 

 

I tried doing cross tab in parallel for both the columns, but i am not sure how to bring it to 2 columns like shown above. Can someone help me with this?

Alteryx Certified Partner

Hi @hash_89 ,

 

Two cross-tabs and a union tool with manually configured options will get you there or close enough, however this isn't a great way to structure your data as the subject values are now just 'floating' with no clear association to the rest of the data.

 

Screenshot 2019-05-15 at 17.15.50.png

 

 

Meteor

Thankyou!

Labels