Help on arranging the records based on KEY value horizontaly

kasthuri Sun Jan 27, 2013 5:25 pm

Posted: Fri Sep 21, 2012 10:12 pm Post subject: Help on arranging the records based on KEY value horizontaly

Hi All,

I have a request to arrange records horizontaly based on key field, please find below the sample data:

Code:
Input file:
1 AAA
1 BBB
2 CCC
2 DDD
3 FFF
3 EEE
3 GGG
The out file should look like

Code:
1 AAA BBB
2 CCC DDD
3 FFF EEE GGG

Is it possible to attain this using a SORT/ICETOOL? if yes, then could you please share me the details

Thanks a many for the help