Compare two input file using sort.

IBM's Sort Product, ICETOOL, ICEMAN and ICEGENER.

Topic author
Mamta LDH
New Member
Posts: 9
Joined: Fri Feb 28, 2014 1:35 am
Has thanked: 2 times

Compare two input file using sort.

Postby Mamta LDH » Tue Mar 07, 2017 1:42 pm

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.




nicc
Global Moderator
Global Moderator
Posts: 510
Joined: Wed Apr 23, 2014 8:45 pm
Been thanked: 10 times

Re: Compare two input file using sort.

Postby nicc » Tue Mar 07, 2017 3:34 pm

search the forum for sort queries involving joinkeys - and read up on the topic in the manual.


Regards
Nic


Return to “IBM DFSort, ICETOOL, ICEMAN, ICEGENER.”

Who is online

Users browsing this forum: CommonCrawl [Bot] and 1 guest