Skip to main content
Solved

Group records in range of Values and time

  • September 20, 2024
  • 3 replies
  • 39 views

nbeekers
Contributor
Forum|alt.badge.img+2

Hello, 

 

Im searching for a solution to give records a group value based on multiple values statements.

 

Data needs to be grouped on a Vehicle in time asc.

So far this is not the problem.

The grouping also needs to Start with a value Status = "Start”and all the other records after Start.

The grouping needs to be closed after Status End comes as a record.

It looks like a range or a ranking.

 

If someone has some idea thanks.

 

Kind regards,

 

Nick

 

Best answer by bwn

 

Leads to AttributeCreator with Adjacent Feature Processing and a Conditional Value that sees if Current Feature = ‘Start’ and previous Feature = ‘End’.  If so Increment Group_ID + 1

 

 

 

 

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

3 replies

bwn
Evangelist
Forum|alt.badge.img+26
  • Evangelist
  • September 20, 2024

There are a couple of ways.  Personally I would use AttributeCreator with Adjacent Feature Handling since it has flexibility in Conditional Value Rules.

First to make sure of the Sorting needed.
 

 

Assuming the rules are, New Group is where:

  • Current Feature “Status” = ‘Start’; and
  • Previous Feature “Status” = ‘End.


Now, use 1 AttributeCreator to create a blank Group_ID Attribute + 1 AttributeCreator that looks at the value of Status for both the current Feature, and the previous Feature.


 

 


bwn
Evangelist
Forum|alt.badge.img+26
  • Evangelist
  • Best Answer
  • September 20, 2024

 

Leads to AttributeCreator with Adjacent Feature Processing and a Conditional Value that sees if Current Feature = ‘Start’ and previous Feature = ‘End’.  If so Increment Group_ID + 1

 

 

 

 


nbeekers
Contributor
Forum|alt.badge.img+2
  • Author
  • Contributor
  • September 20, 2024

Thanks for your insights.

Im gonna run the proces with the settings.


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