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.
Eliminate Matching Records
Previous topic • Next topic • 4 posts
• Page 1 of 1
Eliminate Matching Records
by lukeK » Sat Dec 29, 2012 1:51 am
- lukeK
- Posts: 2
- Joined: Fri Dec 28, 2012 10:36 pm
- Has thanked: 0 time
- Been thanked: 0 time
Re: Eliminate Matching Records
by enrico-sorichetti » Sat Dec 29, 2012 2:15 am
search the forums with
there are quite a few examples, both for DFSORT and SYNCSORT
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
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: 3003
- Joined: Fri Apr 18, 2008 11:25 pm
- Has thanked: 0 time
- Been thanked: 164 times
Re: Eliminate Matching Records
by 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
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
by dick scherrer » Sun Dec 30, 2012 7:37 am
Good to hear it is working - thank you for letting us know 
d
d
-
dick scherrer - Global moderator
- Posts: 6268
- Joined: Sat Jun 09, 2007 8:58 am
- Has thanked: 3 times
- Been thanked: 93 times
Previous topic • Next topic • 4 posts
• Page 1 of 1
-
- Related topics
- Replies
- Views
- Last post
-
- Syncsort get unmatched records & Merging of matching records
by SLEEPLESS » Thu Jun 27, 2013 12:28 pm - 1 Replies
- 3994 Views
- Last post by dick scherrer
Sat Jun 29, 2013 12:12 am
- Syncsort get unmatched records & Merging of matching records
-
- SYNCSORT - Matching records in 2 files
by Ed Chan » Wed Mar 02, 2011 2:39 am - 5 Replies
- 16733 Views
- Last post by Laine
Fri Mar 11, 2011 12:53 am
- SYNCSORT - Matching records in 2 files
-
- Copy records for matching key appearing at different places.
by ranga_subham » Mon Feb 02, 2009 10:57 pm - 2 Replies
- 2072 Views
- Last post by ranga_subham
Tue Feb 03, 2009 11:01 pm
- Copy records for matching key appearing at different places.
-
- Need to Compare 2 files and select matching/MERGE records
1, 2by rockstar2020 » Wed Jan 08, 2014 4:06 pm - 10 Replies
- 6387 Views
- Last post by BillyBoyo
Wed Jan 15, 2014 2:20 pm
- Need to Compare 2 files and select matching/MERGE records
-
- eliminate low values and copy
by ranga_subham » Mon Sep 29, 2008 10:12 pm - 2 Replies
- 4733 Views
- Last post by ranga_subham
Tue Sep 30, 2008 4:35 pm
- eliminate low values and copy