Skip to main content
Question

Change Rows to Columns

  • July 4, 2023
  • 1 reply
  • 51 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+60
  • nielsgerritsVIP
  • 2940 replies
  • July 4, 2023

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.

Buckle your seatbelt Dorothy, cause Kansas is going bye-bye...


Community Stats

32,102
Posts
121,897
Replies
39,750
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.