Skip to main content
  • EN

Dear colleagues,

I'm looking for a way to perform updates within 1 table based on consecutive attribute values. In the attached picture I want to increase/adjust the “Traject_volgnr” if this condition is met for 2 consecutive features : “Route4” is the same but the difference between the consecutive “Hm_pos” is greater than 2.

 

In the example this should give the following result: Line 15089 - 15093 the "Traject_volgnr" remains 1 but in lines 15094 - 1598 the "Traject_volgnr" changes to 2 (or another value).

FME update 

 

So if you turn on Adjacent Attribute Handling in the Attribute Creator and look at 1 previous feature you can then do a conditional statement something like this.

imageTesting if the Route4 attribute matches the value of the previous feature and checking if the difference in Hm_pos is greater than 2. If these conditions are met you then set Tracject_volgnr to something else

Thank you! this is exactly what i was looking for. I've implemented it and it works great!

 

 

 

Reply


Community Stats

30,168
Posts
114,524
Replies
37,824
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.