Ah, I see. The reason your example does not quite do what I'm looking for is because the second 5 in the 2 5 row should NOT match to the first 5 in the 5 8 row. I want only equal values of match_1 to match to each other, and only equal values of match_2 to match to each other. So for example in this wrong triplet, the match_2 in the first two rows is correct, but match_1 in the second two rows is not equal and therefore incorrect:
ID
case
match_1
match_2
26229681701
0
100000025
1549255201
1
100000021
100000025
28654518402
0
100000025
I would instead like it to look like this:
ID
case
match_1
match_2
26229681701
0
100000025
1549255201
1
100000021
100000025
2280537501
0
100000021
Does that help? Thank you!!!
@novinosrin wrote:
If you could post some expected correct ones for the incorrect ones, that would help.
What I means to ask or say is, should you have something like the below
1 2
5 8
3 9
2 5
Let's begin matching
Take 1, look up , no matches found. Since this is starting, increment case counter =1;
Take 2, perform look up, look forward 3 records where you find a match with 4th records 2 5, so case counter for 1 2 and 2 5 is 1. However 5 matches with 5 8 in 2nd record, so again the case counter is still 1 for 1 2, 2 5, 5 8 .
Next starting from 3 9, is a new start, so increment case counter by 1, so case counter=case counter +1 which is equal to 2. Repeat the process again until all records are scanned.
Is my understand correct?
... View more