This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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:
Label | Category | Value |
Mood | Aggresive | 1 |
Mood | Quiet | 0 |
Mood | Relaxing | 0 |
Artist | A | 0 |
Artist | B | 1 |
Artist | C | 0 |
Genre | Jazz | 0 |
Genre | Rock | 1 |
Genre | Pop | 0 |
and this is how I need it:
Mood | Artist | Genre | Value |
Aggresive | 1 | ||
Quiet | 0 | ||
Relaxing | 0 | ||
A | 0 | ||
B | 1 | ||
C | 0 | ||
Jazz | 0 | ||
Rock | 1 | ||
Pop | 0 |
Thanks in advance and cheers,
Armin
Solved! Go to Solution.
Hi @ArminL,
Please go through with attached workflow, it will get exactly as u required.
Thanks,
Vishwa
many thanks!