Skip to main content
Solved

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

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 

View original
    Did this help you find an answer to your question?

    2 replies

    geomancer
    Evangelist
    Forum|alt.badge.img+48
    • geomancerEvangelist
    • Evangelist
    • 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
    • June 15, 2023

    Perfect! Thank you

    Reply


    Helpful Members This Week

    Community Stats

    31,224
    Posts
    118,406
    Replies
    38,827
    Members

    Latest FME

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

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