Skip to main content
Question

How to pivot table?

katt
Supporter
Forum|alt.badge.img+12
  • kattSupporter
  • Supporter
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.

    2 replies

    ebygomm
    Influencer
    Forum|alt.badge.img+38
    • ebygommInfluencer
    • Influencer
    • May 27, 2020

    An attribute creator followed by an aggregator and an attribute exposer

    daraghatsafe
    Forum|alt.badge.img

    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


    Helpful Members This Week

    Community Stats

    31,336
    Posts
    118,868
    Replies
    38,958
    Members

    Latest FME

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie 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.