Skip to main content
Question

How to pivot table?

  • May 27, 2020
  • 2 replies
  • 64 views

katt
Supporter
Forum|alt.badge.img+12
  • Supporter
  • 41 replies
Hello, I have a table like this:

 

System ErrorAffected RegionTotal Error 1City2Error 1Village5Error 2City 7Error 2Village3

 

What I would like to have is this:

Affected Region

 

Error 1Error 2City

 

27Village

 

53

 

What transformer do I need to use to change the table structure?

Thanks.

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

ebygomm
Influencer
Forum|alt.badge.img+44
  • Influencer
  • 3427 replies
  • May 27, 2020

An attribute creator followed by an aggregator and an attribute exposer


daraghatsafe
Forum|alt.badge.img
  • 135 replies
  • May 27, 2020

Hey @katt.

This tutorial should help you out, enjoy!

https://knowledge.safe.com/articles/31702/pivot-table-using-fme.html

Let us know if this helps.