Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Table Structure (Cross-tab?)

ArminL
7 - 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

 

2 REPLIES 2
vishwa_0308
11 - Bolide

Hi @ArminL,

 

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

 

Thanks,

Vishwa

ArminL
7 - Meteor

many thanks! 

Labels