Skip to main content
Solved

Want to split an attribute, then make new rows that insert the separated values into the new rows

  • May 14, 2024
  • 2 replies
  • 154 views
schulte.a
Contributor
Forum|alt.badge.img+3

I have a table where I have emergency meeting points. Each building has a meeting point, some buildings have many points, here is an example:

Building Meet_Points
123 11,12,13
124 16

 

I would like the table to look like this:

Building Meet_Points
123 11
123 12
123 13
124 16

 

How would I separate those meet points, and make numerous rows of the same building that has each meet point and all the other attributes carry over to the newly made rows and are the same?

Best answer by liamfez

You can use an AttributeSplitter on the meeting points attribute. It will create a list and then you can use the ListExploder to explode that list into multiple features.

    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

    liamfez
    Influencer
    Forum|alt.badge.img+44
    • liamfezInfluencer
    • Influencer
    • Best Answer
    • May 14, 2024

    You can use an AttributeSplitter on the meeting points attribute. It will create a list and then you can use the ListExploder to explode that list into multiple features.

    Rotate monitor to the right to improve translation speed using gravity
    geomancer
    DanAtSafe
    schulte.a
    Contributor
    Forum|alt.badge.img+3
    • schulte.aContributor
    • Author
    • Contributor
    • May 15, 2024

    Awesome, i’ll give that a shot! Thanks for the help :)

    Community Stats

    32,154
    Posts
    122,043
    Replies
    39,812
    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.