Skip to main content

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

 

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.


 

 


 

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

 

 

 

 


Thanks for your insights.

Im gonna run the proces with the settings.


Reply