Skip to main content
Question

Change Rows to Columns

  • July 4, 2023
  • 1 reply
  • 27 views

serge
Participant
Forum|alt.badge.img

I have a flow source 

Movie    Role    Actor
M1         R1        A1,A2
M1         R2        A1,A3
M2         R1        A2

 

and I need to switch to the vue 

Movie     R1      R2
M1      A1,A2    A1,A3
M2        A2

how is it possible, I tried AttributePivoter but didn't find a way to switch rows to columns.

 

The Roles list is not known before, so it should take all unique roles as columns.

1 reply

nielsgerrits
VIP
Forum|alt.badge.img+54

I think you want to transpose your table. In this topic multiple options are explained on how to do that.

 

Your next question is probably: "Can I automatically expose attributes?" The answer is No, but there are ways to deal with unexposed attributes, as can be read in this topic.

 

No offence :) but linking to the other questions saves me rewriting the answers.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings