karthikr44
Active User
Joined: 25 Aug 2007 Posts: 235 Location: Chennai
|
|
|
|
Hi,
I file (FB/200):
---------------
G111 A
G111 A
G222 A
G222 B
G222 C
G222 C
G333 A
G333 B
G444 A
G444 A
G555 A
II file (FB/250):
-----------------
G111 Z
G111 Y
G222 Z
G222 Z
G333 Z
MATCHED O/P FILE I M GETTING NOW:
--------------------------------
G111 A
G222 A
G222 B
G222 C
G333 A
G333 B
MISMATCHED O/P FILE I M GETTING NOW:
--------------------------
G444 A
G555 A
EXPECTED MATCHED O/P FILE:
--------------------------
G111 A
G111 A
G222 A
G222 B
G222 C
G222 C
G333 A
G333 B
EXPECTED MISMATCHED O/P FILE:
--------------------------
G444 A
G444 A
G555 A
Here both file 1 and file may have duplicate records. I want to compare file1 and file2 based on key (1,4) and want to create matched file1 and mismatched file1. Here i want the duplicates from FILE1.
SORT CARD I USED:
------------------------
Code: |
JOINKEYS FILES=F1,FIELDS=(1,4,A)
JOINKEYS FILES=F2,FIELDS=(1,4,A)
JOIN UNPAIRED
REFORMAT FIELDS=(F1:1,200,F2:1,4),FILL=X'FF'
SORT FIELDS=(1,200,CH,A)
SUM FIELDS=NONE
OUTFIL FNAMES=NOMATCH1,
INCLUDE=(201,1,BI,EQ,X'FF'),
BUILD=(1,200)
OUTFIL FNAMES=MATCH1,
INCLUDE=(1,1,BI,NE,X'FF',AND,
201,1,BI,NE,X'FF'),
BUILD=(1,200)
|
I want to achieve in single step using SYNCSORT JOINKEYS.
Please share ur thoughts,
Thanks in advance
R KARTHIK |
|