Skip to main content
Solved

Group records in range of Values and time

  • September 20, 2024
  • 3 replies
  • 72 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

 

 

 

 

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.

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.