what is the sortcard for comparing two files with a field key and get the dupli

what is the sortcard for comparing two files with a field key
and get the duplicates in onefile and noduplicates in another
file

Question Posted / annie

3 Answers
12407 Views
Virtusa, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the sortcard for comparing two files with a field key and get the duplicates in onefile and..

Answer / sv

sort fields = copy
sum fields = none,xsum

Is This Answer Correct ?

12 Yes

3 No

what is the sortcard for comparing two files with a field key and get the duplicates in onefile and..

Answer / arthi

JOINKEYS F1=FILE1,FIELDS=(1,10,A)
JOINKEYS F2=FILE2,FIELDS=(1,10,A)
JOIN UNPAIRED,F1,F2
REFORMAT FIELDS=(F1:1,10,F2:1,10)
INREC IFTHEN=(WHEN(1,10,CH,NE,11,10,CH),OVERLAY=(22:C'N'))
OUTFIL FNAMES=MATCHED,INCLUDE=(22,1,CH,EQ,C'B')
OUTFIL FNAMES=UNMATCHED,INCLUDE=(22,1,CH,EQ,C'N')

Is This Answer Correct ?

4 Yes

0 No

what is the sortcard for comparing two files with a field key and get the duplicates in onefile and..

Answer / vinodh

Refining the above sort card statement after executing it

SORT FIELDS=COPY
JOINKEYS FILES=F1,FIELDS=(1,10,A)
JOINKEYS FILES=F2,FIELDS=(1,10,A)
JOIN UNPAIRED,F1,F2
REFORMAT FIELDS=(F1:1,10,F2:1,10)
INREC IFTHEN=(WHEN(1,10,CH,NE,11,10,CH),OVERLAY=(22:C'N'))
OUTFIL FNAMES=MATCH,INCLUDE=(22,1,CH,EQ,C' ')
OUTFIL FNAMES=UNMATCH,INCLUDE=(22,1,CH,EQ,C'N')

Is This Answer Correct ?

3 Yes

0 No

Post New Answer