Skip to main content
Solved

how to select rows based on start and end values from previous rows

  • June 15, 2023
  • 2 replies
  • 137 views
gcarmich
Participant
Forum|alt.badge.img+1

I have a table of values with ID, Start, and End. Starting with the first row, I need to select the next row where the start value equals the end value of the first row. I need to repeat this process for the entire table.

 

For example, I'd select row 1 then row 4 then row 6 then row 9 then row 13...

imageAny thoughts on how to do this?

 

Best answer by geomancer

You can accomplish this by looking at the attributes of the previous feature ('Enable Adjacent Feature Attributes'), and add some logic. Next step: keep only the features where Keep = 'Y'.

Start_is_End 

    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.

    2 replies

    geomancer
    Evangelist
    Forum|alt.badge.img+58
    • geomancerEvangelist
    • Evangelist
    • 932 replies
    • Best Answer
    • June 15, 2023

    You can accomplish this by looking at the attributes of the previous feature ('Enable Adjacent Feature Attributes'), and add some logic. Next step: keep only the features where Keep = 'Y'.

    Start_is_End 

    gcarmich
    Participant
    Forum|alt.badge.img+1
    • gcarmichParticipant
    • Author
    • Participant
    • 35 replies
    • June 15, 2023

    Perfect! Thank you

    Community Stats

    32,058
    Posts
    121,724
    Replies
    39,686
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility statement
    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.