Skip to main content
  • EN

Hello,

I have a dataset that looks similar to the image shown and I need to create the value in the attribute ROUTE shown in red. image.pngI need to create a new value for ROUTE whenever Duration>1 or Duration is Null. 

The data needs to be sorted firstly by Name, then by TimeStamp.

Then, whenever the previously mentioned condition of (Duration>1 or Duration is Null) is met, a new value needs to be created for ROUTE. 

How do I create a new value (with for example a new sequential number) whenever I come across (Duration>1 or Duration is Null) in my sorted data?

Use the Adjacent Feature Attributes option of the AttributeManager to have access to the attributes of the previous feature, and provide your logic as a Conditional Value.

Routenumber(Note: I added some extra logic where Name B begins. This may not be needed.)

Use the Adjacent Feature Attributes option of the AttributeManager to have access to the attributes of the previous feature, and provide your logic as a Conditional Value.

Routenumber(Note: I added some extra logic where Name B begins. This may not be needed.)

That did the trick, thank you

Reply


Community Stats

30,117
Posts
114,317
Replies
37,748
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.