Skip to main content
  • EN

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.

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.

Reply


Community Stats

30,351
Posts
115,343
Replies
38,086
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.