Page 1 of 1

Matched record and unmatched record in the same output file

PostPosted: Thu Mar 17, 2016 8:44 pm
by Papya013
I have below mentioned input files:

File1:

3111 252700 HEAD N X
3111 252800 HEAD N Y


File 2:

3111 252700 HEAD J
3111 252800 HEAD J
3111 252810 HEAD N


Output I am looking at is:

3111 252700 HEAD J X
3111 252800 HEAD J Y
3111 252810 HEAD N


Could you please help me on this. I tried to use join keys but didn't work.

SORT FIELDS=COPY                      
JOINKEYS FILES=F1,FIELDS=(6,7,A)
JOINKEYS FILES=F2,FIELDS=(6,7,A)
JOIN UNPAIRED,F1,F2                    
REFORMAT FIELDS=(F1:1,20)    

Re: Matched record and unmatched record in the same output f

PostPosted: Thu Mar 17, 2016 9:07 pm
by NicC
didn't work.

means absolutely nothing unless you state how it doesn't work - with examples if neccessary.