Page 1 of 1

Compare two input file using sort.

Posted: Tue Mar 07, 2017 1:42 pm
by Mamta LDH
Hi,

One of my Input file is :

Code: Select all

Robert 26 male 
Ronald 24 male 
Jennifer 22 female 
Second Input file is:

Code: Select all

1245 Robert Newyork 26 AMEX 
1237 Jennifer Nevada 22 RBS 
4356 Ronald Arizona 24 Fox 
Output file should be:

Code: Select all

1245 Robert Newyork 26 AMEX male 
1237 Jennifer Nevada 22 RBS female 
4356 Ronald Arizona 24 Fox male 
Can we do this using SORT, please help me with the process.

Re: Compare two input file using sort.

Posted: Tue Mar 07, 2017 3:34 pm
by nicc
search the forum for sort queries involving joinkeys - and read up on the topic in the manual.