Solved

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

cyrusa
Rank
Badge

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!

icon

Best answer by ebygomm 10 May 2019, 16:05

View original

2 replies

ebygomm
Rank
Userlevel 1
Badge +10

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
Rank
Badge

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!!!

Reply


Community Stats

28,668
Posts
109,356
Replies
36,532
Members
Terms & ConditionsCookie settings
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.