merging multiple rows based on unique value using scripting or sql

I have a file like the one below.


11111 |Y |N |N |N |aaaaa| | |
11111 |N |Y |N |N | |pre | |

11111 |N |N |Y |N | | | |FBBr

Now I want a file which combines all the three rows and it should be like the one below.Except the cstmr_id all other fields should be appended as it is


11111 |Y |N |N |N |aaaaa| | | N |Y |N |N | |pre | | N |N |Y |N | | | |FBBr

Can someone help me in acheiving this using shell scriptiong or sql?

Thanks in advance.


Source: unix

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.