Combine records using SORT.

IBM's Sort Product, ICETOOL, ICEMAN and ICEGENER.
Previous topicNext topic

Topic Author
Raja Chand
New Member
Posts: 7
Joined: Tue May 31, 2016 11:13 pm

Combine records using SORT.

Post by Raja Chand » Sat Apr 29, 2017 10:35 pm

Hi,

I have an input file which looks like this -

Code: Select all

76767 YZY 
76767 XYZ 
76767 ### 
23452 YZY 
23452 DDD 
I am trying to get an out put like this, is it possible to get to that using SORT application?

Code: Select all

76767 YZY XYZ ### 
23452 YZY DDD 




zprogrammer
Global Moderator
Global Moderator
Posts: 605
Joined: Wed Nov 20, 2013 11:53 am
Location: Mars
Zodiac: Libra

Re: Combine records using SORT.

Post by zprogrammer » Tue May 16, 2017 11:22 pm

How many duplicates do you expect for a given key?


zprogrammer


Topic Author
Raja Chand
New Member
Posts: 7
Joined: Tue May 31, 2016 11:13 pm

Re: Combine records using SORT.

Post by Raja Chand » Wed May 17, 2017 12:48 pm

1 to 3. Not more than that.



Previous topicNext topic

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