Solved

Concatenate parts of lists


Badge +9

I have run some stats on a dataset where features fall into a specific polygon and have the count and the category.

image 

I now need a list that I can bring together in a single concatenated value that is {count1, cat1, count2, cat2, count3, cat3}

 

The problem is that the number of the categories varies from polygon to polygon.

 

The approach so far is statistics calculator => list builder => list concatenator (using category) => list concatenator (using count) which gives me two lists, comma separated but need to being them together.

 

imagewith the result

imageDoes anyone have any suggestions on how to bring together?

 

icon

Best answer by geomancer 3 May 2022, 10:20

View original

4 replies

Badge +10

Is there a reason you can't join the severity and the count prior to building the list?

Userlevel 3
Badge +33

My thoughts exactly.

Severity

Badge +9

Thanks for helping me to open my eyes​

Badge +9

Just an update as the solution worked as expected but just wanted to share a couple of changes. I had to add a ListDuplicateRemover to ensure the entries were unique. I also needed to add a FeatureMerger as I had lots of stats to merge together. Thanks @geomancer​ amd @ebygomm​ as sometimes you can't see the obvious.

 

image

Reply