Hi folks,
I’m trying to identify overlaps in records from within the same table. I’m drawing a blank on how to do this. As you can see from the screenshot, the red highlighted row has a From - To range that overlaps with the range from the sample above. I need to be able to identify these overlaps so I can split them out from the table.
Any suggestions would be appreciated.
Could you please share some data so potential helpers don’t have to manually create it? Is it possible for the yellow row to be 27.00 - 30.00 and the red row to be 28.00 - 30.00? If so would this constitute an overlap? Can more than two consecutive rows overlap?
Hi @davidbaker,
with the “lag column” node you can find these overlapping rows easily.
As “FROM” is a double/float value I would always filter using a delta calculation and tolerance value for defining values as “equal”. You can find this “delta” in the Rule-based filter. I set it to 1e-5 which is sufficient that kind of number range.
Thank you @ActionAndi! Lag did the trick. Very handy node 
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
