Hi I have 2 files as below, need to compare them and get all the unmatched records . I used join keys but getting in the output prevoius week records only.
Previous Week File |AV0000012620009 | 0.68| |AV0000012621410 | 1.09| |AV0000012621504 | 0.88| Current Week file |AV0000012620009 | 0.98| |AV0000012621410 | 1.99| |AV0000012621504 | 0.98| |AV0000012621502 | 0.78| Output |AV0000012620009 | 0.68| |AV0000012621410 | 1.09| |AV0000012621504 | 0.88| Desired o/p |AV0000012620009 | 0.98| |AV0000012621410 | 1.99| |AV0000012621504 | 0.98| |AV0000012621502 | 0.78| Sort card used JOINKEYS F1=SORTIN1,FIELDS=(2,44,A) JOINKEYS F2=SORTIN2,FIELDS=(2,44,A) JOIN UNPAIRED,F1,F2,ONLY OPTION COPY OUTFIL VTOF,BUILD=(5,133) Thanks Ron T ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN