Skip to main content
Solved

How can I pivot a table, concatenate strings and sort (see screenshot)

  • May 10, 2019
  • 2 replies
  • 23 views
cyrusa
Contributor
Forum|alt.badge.img+3

Hi all,

I think I have a quite simple question here. But i'm stuck in my thoughts.

I have a dataset (see left table in picture below) and I want to have an overview of which numbers are in a certain cluster. Does anyone have some hints for me?

Thanks in advance!

Best answer by ebygomm

Listbuilder group by cluster, list sorter to sort by NR, listconcatenator to create NEW attribute, listexploder to get back to original features, attributecreator to add the element index on to the end of the NEW attribute

    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

    ebygomm
    Influencer
    Forum|alt.badge.img+44
    • ebygommInfluencer
    • Influencer
    • 3427 replies
    • Best Answer
    • May 10, 2019

    Listbuilder group by cluster, list sorter to sort by NR, listconcatenator to create NEW attribute, listexploder to get back to original features, attributecreator to add the element index on to the end of the NEW attribute

    cyrusa
    Contributor
    Forum|alt.badge.img+3
    • cyrusaContributor
    • Author
    • Contributor
    • 4 replies
    • May 13, 2019

    Listbuilder group by cluster, list sorter to sort by NR, listconcatenator to create NEW attribute, listexploder to get back to original features, attributecreator to add the element index on to the end of the NEW attribute

    @egomm Thanks a lot. This worked perfectly!!!

    Community Stats

    32,080
    Posts
    121,820
    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.