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 A2how 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.
+34
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
