Skip to main content
Question

Issues "transposing" a table in FME

  • May 18, 2020
  • 5 replies
  • 38 views
M
Forum|alt.badge.img

Hello, I am having some issues getting the proper format of a table I am trying to transpose. I attempted a couple of methods using the FMEHub AttributeTransposer and did not get the required results. If you see it is almost a half transpose, I need to get the records in the first sheet to line up like the records in the second sheet in the attached spreadsheet . I have hit a roadblock.

 

    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.

    5 replies

    J
    Forum|alt.badge.img+2
    • jlbaker2779
    • 194 replies
    • May 18, 2020

    There is a video tutorial. I've done it a few times and it works fairly well.

     

    https://knowledge.safe.com/articles/31701/transpose-a-table-using-fme.html

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

    This is how I would approach this

    1. Create a the new attribute named according to the Filter type
    2. Aggregate the records based on the name
    3. Expose the newly created attributes
    4. Remove the now unneeded filter attributes

    You probably also want a null attribute mapper if you want missing values to be set to 0

     

    M
    Forum|alt.badge.img
    • morijlumos
    • Author
    • 22 replies
    • May 18, 2020

    This is how I would approach this

    1. Create a the new attribute named according to the Filter type
    2. Aggregate the records based on the name
    3. Expose the newly created attributes
    4. Remove the now unneeded filter attributes

    You probably also want a null attribute mapper if you want missing values to be set to 0

     

    Thank you for the help! I cannot tell what I am doing wrong here?

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

    Thank you for the help! I cannot tell what I am doing wrong here?

    In the attribute creator you have not selected the Filter type attribute correctly, you need to use the drop down arrow, and choose attribute value, then choose filter type. It should then display as @Value(FILTER_TYPE)
    M
    Forum|alt.badge.img
    • morijlumos
    • Author
    • 22 replies
    • May 18, 2020
    In the attribute creator you have not selected the Filter type attribute correctly, you need to use the drop down arrow, and choose attribute value, then choose filter type. It should then display as @Value(FILTER_TYPE)

    Oh jeez, Amazing! Thanks so much.

    Community Stats

    32,076
    Posts
    121,791
    Replies
    39,702
    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.