Skip to main content
Solved

How to group attributes and generate group id based on 2 fields

  • December 15, 2022
  • 4 replies
  • 90 views

Group ID should start from 1 for each unique Attribute 1 value and the smallest value of Attribute 2 for each Attribute 1 value should get it as follows:

image

Best answer by dustin

_jami_ wrote:

Did you really get Counter to start from 1 for each attribute1 value?

Ahh, one small correction. I have attached the workspace. The group by needs to be set in the Counter:

image

View original
Did this help you find an answer to your question?

4 replies

dustin
Influencer
Forum|alt.badge.img+30
  • Influencer
  • December 15, 2022

Probably a few ways to get this result, but this should work.

  • Aggregate based on Attribute1 and Attribute2
  • Sort based on Attribute1 and Attribute2
  • Counter gives the aggregated features the GROUP_ID
  • Deaggregate, which retains the GROUP_ID on the individual features.

image


  • Author
  • December 15, 2022

Did you really get Counter to start from 1 for each attribute1 value?


dustin
Influencer
Forum|alt.badge.img+30
  • Influencer
  • December 15, 2022
_jami_ wrote:

Did you really get Counter to start from 1 for each attribute1 value?

I really did😀 In the Counter, you can specify the Count Start with '1'.


dustin
Influencer
Forum|alt.badge.img+30
  • Influencer
  • Best Answer
  • December 15, 2022
_jami_ wrote:

Did you really get Counter to start from 1 for each attribute1 value?

Ahh, one small correction. I have attached the workspace. The group by needs to be set in the Counter:

image


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings