AAA;2007-01-01;2009-12-31 <---combination of row1,3
The logic here is to see if the Key(first 3 bytes) is same, then check if the dates have continuity in them (i.e There is 'no gap' between Start date of row1 and end date of row2).
Will it be possible to use Sort - or will have to stick to COBOL to achieve the same. Please help.
(Sort Installed in Shop:Syncsort)