Skip to main content
Solved

Transposing rows to columns

  • December 15, 2022
  • 2 replies
  • 1693 views
superjets
Contributor
Forum|alt.badge.img+1

This would be simple to do in Excel, but I can't figure it out on FME. The problem is I need to transpose or pivot rows to colums, as in example (I have formatted and calculated the totals to first box):

imageI have tried with AttributePivoter and AttributeCreator/Aggregator, but it doesn't work. Any help would be appreciated, I've tried to google, but with no luck. I have also tried to pivot the unprocessed data and calculate it there.

Best answer by tomfriedl

tableParams FeatureMerger:

Group by name

Merge incoming attributes

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

tomfriedl
Contributor
Forum|alt.badge.img+13
  • tomfriedlContributor
  • Contributor
  • 177 replies
  • Best Answer
  • December 15, 2022

tableParams FeatureMerger:

Group by name

Merge incoming attributes

https://community.safe.com/general-10/fme-form-starter-20721
superjets
Contributor
Forum|alt.badge.img+1
  • superjetsContributor
  • Author
  • Contributor
  • 3 replies
  • December 15, 2022

Yeah, thanks a ton! With help of AttributeExposer it worked.

That was super-fast!

image

Community Stats

32,066
Posts
121,745
Replies
39,692
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.