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
SOLVED

Table Structure (Cross-tab?)

Meteor

Hey everybody,

 

I have a problem with a table structure, which can probably be solved with a cross tab tool. Still I can't figure out how to configure it to get the right ouput. maybe somebody could quickly help me with that minor problem :) Here is what I have right now:

LabelCategoryValue
MoodAggresive1

Mood

Quiet0
MoodRelaxing0
ArtistA0
ArtistB1
ArtistC0
GenreJazz0
GenreRock1
GenrePop0

 

and this is how I need it: 

MoodArtistGenreValue
Aggresive  1
Quiet  0
Relaxing  0
 A 0
 B 1
 C 0
  Jazz0
  Rock1
  Pop0

 

Thanks in advance and cheers,

Armin

 

Alteryx Certified Partner

Hi @ArminL,

 

Please go through with attached workflow, it will get exactly as u required.

 

Thanks,

Vishwa

Meteor

many thanks! 

Labels