Skip to main content
Best Answer

Concatenate parts of lists

  • May 3, 2022
  • 4 replies
  • 116 views

deanhowell
Influencer
Forum|alt.badge.img+24

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?

 

Best answer by geomancer

My thoughts exactly.

Severity

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.

4 replies

ebygomm
Influencer
Forum|alt.badge.img+46
  • Influencer
  • May 3, 2022

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


geomancer
Evangelist
Forum|alt.badge.img+60
  • Evangelist
  • Best Answer
  • May 3, 2022

My thoughts exactly.

Severity


deanhowell
Influencer
Forum|alt.badge.img+24
  • Author
  • Influencer
  • May 3, 2022

Thanks for helping me to open my eyes​


deanhowell
Influencer
Forum|alt.badge.img+24
  • Author
  • Influencer
  • May 4, 2022

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