Eliminate Matching Records



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

Eliminate Matching Records

Postby lukeK » Sat Dec 29, 2012 1:51 am

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.
lukeK
 
Posts: 2
Joined: Fri Dec 28, 2012 10:36 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Eliminate Matching Records

Postby enrico-sorichetti » Sat Dec 29, 2012 2:15 am

search the forums with
joinkeys

there are quite a few examples, both for DFSORT and SYNCSORT
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: Eliminate Matching Records

Postby lukeK » Sat Dec 29, 2012 2:55 am

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
lukeK
 
Posts: 2
Joined: Fri Dec 28, 2012 10:36 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Eliminate Matching Records

Postby dick scherrer » Sun Dec 30, 2012 7:37 am

Good to hear it is working - thank you for letting us know :)

d
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post