Remove Duplicates + Original Record
Posted: Fri Nov 12, 2010 10:07 pm
Is there a way to use Syncsort to produce the following? All records with unique keys go to Output file 1 and all duplicate records plus the respective original record go to Output file 2.
Example:
Input
Output file 1:
Output file 2:
Example:
Input
0001
0002
0002
0003
0004
0005
0005
0002
0002
0003
0004
0005
0005
Output file 1:
0001
0003
0004
0003
0004
Output file 2:
0002
0002
0005
0005
0002
0005
0005