Need unique records using sort or join
Posted: Sun Nov 16, 2014 3:02 pmHi,
I have two input flat files(FB) with different record length. I need to get only the unique records from particular positions to 1st output file & non-unique records
to 2nd output file.
Input File 1:
100 123 AAA
200 234 BBB
Input File 2:
ABC ZZZ 100 QQQ AAA
ABC XXX 300 QQQ CCC
1st - Output file Need Output like below:
100 AAA
200 BBB
300 CCC
2nd - Output file Need Output like below:
100 AAA
How can we achieve the above result using sort. Please help
Thanks in Advance
I have two input flat files(FB) with different record length. I need to get only the unique records from particular positions to 1st output file & non-unique records
to 2nd output file.
Input File 1:
100 123 AAA
200 234 BBB
Input File 2:
ABC ZZZ 100 QQQ AAA
ABC XXX 300 QQQ CCC
1st - Output file Need Output like below:
100 AAA
200 BBB
300 CCC
2nd - Output file Need Output like below:
100 AAA
How can we achieve the above result using sort. Please help
Thanks in Advance