Page 1 of 1

Eliminate Matching Records

PostPosted: Sat Dec 29, 2012 1:51 am
by lukeK
I have a problem that I can't quite figure out, and I'm not sure if it is possible.
What I have is two sets of data with a matching key. I want a sort/merge that eliminates records from file 1 if the key is found in file two

ie

F1
AAAAA
BBBBBB
BBBBBB
CCCCC
DDDDD

F2
BBBBBB
CCCCC

Output
AAAAA
DDDDD

Does anyone have any idea if this is possible or where to begin on accomplishing this? I have been searching online and through the reference guide but I can't seem to find anything.

Re: Eliminate Matching Records

PostPosted: Sat Dec 29, 2012 2:15 am
by enrico-sorichetti
search the forums with
joinkeys

there are quite a few examples, both for DFSORT and SYNCSORT

Re: Eliminate Matching Records

PostPosted: Sat Dec 29, 2012 2:55 am
by lukeK
Thank you, I had seen those before but never with excluding a record. This post helped me solve my problem and I have it working.

syncsort-synctool/topic5406.html

Re: Eliminate Matching Records

PostPosted: Sun Dec 30, 2012 7:37 am
by dick scherrer
Good to hear it is working - thank you for letting us know :)

d