Page 1 of 1

Combine records using SORT.

Posted: Sat Apr 29, 2017 10:35 pm
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 

Re: Combine records using SORT.

Posted: Tue May 16, 2017 11:22 pm
by zprogrammer
How many duplicates do you expect for a given key?

Re: Combine records using SORT.

Posted: Wed May 17, 2017 12:48 pm
by Raja Chand
1 to 3. Not more than that.