Range Lookup question
Posted: Fri Apr 06, 2018 1:28 pm
Hi,
I have data like this.
Here I am looking to reject/capture the first two records where there is an overlap. i.e for the same key, the end should not fall between the start and end of the other record(with the same key). and the start should not fall between the start and end of the other record. basically the overlapping records.
I tried using Range lookup, withe input and reference as the same but i am not able to apply both the conditions.
The condition should be start not between start and end OR end not between start and end.
Range lookup is only able to do AND condition.
Is there a way to do that?
Thanks!
I have data like this.
Code: Select all
key, start, end
1,1,100
1,80,140
2,200,300
4,250,300
I tried using Range lookup, withe input and reference as the same but i am not able to apply both the conditions.
The condition should be start not between start and end OR end not between start and end.
Range lookup is only able to do AND condition.
Is there a way to do that?
Thanks!