Skip to main content
  • EN
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.

An attribute creator followed by an aggregator and an attribute exposer

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.

Reply


Community Stats

30,182
Posts
114,566
Replies
37,845
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.