Skip to main content
Solved

Tranposing data into new format

  • July 11, 2019
  • 2 replies
  • 8 views
E
Forum|alt.badge.img

I am trying to transpose data. I already read some posts about how to transpose a table using FME. But I am not able to get what I want.

I have the following table within FME:

I want to transpose the data so I get the following format:

So I don't need my column names. This is just an indication for myself.

Does anybody know which transformer(s) I need to use?

Best answer by takashi

If I understand the requirement correctly, this workflow does the trick.

    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

    takashi
    Celebrity
    • takashiCelebrity
    • 7843 replies
    • Best Answer
    • July 11, 2019

    If I understand the requirement correctly, this workflow does the trick.

    Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?
    E
    Forum|alt.badge.img
    • eva218
    • Author
    • 21 replies
    • July 12, 2019

    @takashi, it indeed does exactly what I need! Thank you so much :-)

    Community Stats

    32,080
    Posts
    121,818
    Replies
    39,714
    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.