Updates within a table based on consecutive attribute values

Question

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).

ebygomm · Accepted Answer

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.

Testing 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

pschout · Answer

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

Updates within a table based on consecutive attribute values

2 replies

Reply

Community Stats

Reply

Community Stats

Sign up

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Scanning file for viruses.

This file cannot be downloaded