Skip to main content
Question

Pivoting a table with new field names based on attribute values

  • September 19, 2019
  • 2 replies
  • 33 views
R
Forum|alt.badge.img+1

Hello all,

Can anyone help me in transforming my feature schema as per the included screenshot? I need to create new field names based on distinct data values held within the existing ‘Attr_Type’ field, and then populate these new fields with the relevant ‘Attr_Value’ value.

I’m using FME Desktop v2019.0.2

TIA,

RB

    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

    danilo_fme
    Celebrity
    Forum|alt.badge.img+51
    • danilo_fmeCelebrity
    • Celebrity
    • 2077 replies
    • September 21, 2019

    Hi @robinb

    I tested here in my computer your support.

    For the solve this, I used just a transformer AttributeManager.

    Inside this transformer I configurated like bellow:

    As you can check the Workspace template ( attached ), I search for the values from attributees A,B,C - and set the attribute value = Attr_Value.

     

    The result:

     

    Thanks in Advance Workspace_Xls.fmwt

     

    Danilo

    Partner Solutial Brazil - www.solutial.com.br
    R
    Forum|alt.badge.img+1
    • robinb
    • Author
    • 13 replies
    • September 23, 2019

    Hi @robinb

    I tested here in my computer your support.

    For the solve this, I used just a transformer AttributeManager.

    Inside this transformer I configurated like bellow:

    As you can check the Workspace template ( attached ), I search for the values from attributees A,B,C - and set the attribute value = Attr_Value.

     

    The result:

     

    Thanks in Advance Workspace_Xls.fmwt

     

    Danilo

    Thanks @danilo_fme - that has got me forward to the next step.

    Community Stats

    32,079
    Posts
    121,814
    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.