Combine records using SORT.

IBM's Sort Product, ICETOOL, ICEMAN and ICEGENER.
Post Reply
Raja Chand
New Member
Posts: 7
Joined: Tue May 31, 2016 11:13 pm

Combine records using SORT.

Post by Raja Chand »

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: 588
Joined: Wed Nov 20, 2013 11:53 am
Location: Mars

Re: Combine records using SORT.

Post by zprogrammer »

How many duplicates do you expect for a given key?
zprogrammer
Raja Chand
New Member
Posts: 7
Joined: Tue May 31, 2016 11:13 pm

Re: Combine records using SORT.

Post by Raja Chand »

1 to 3. Not more than that.
Post Reply

Create an account or sign in to join the discussion

You need to be a member in order to post a reply

Create an account

Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute

Register

Sign in

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