Concatination
Posted: Tue Dec 07, 2010 4:38 pm
Hi Guys
I need an Idea to implement the following logic
Can any one suggest me
My Src seems like
ID---SEQNO---MSG
100--- 1--- X
200--- 1--- Y
300--- 1--- A
300--- 2--- B
300--- 3--- C
400--- 1--- A
400--- 2--- B
Output should be like
ID---- MSG
100--- X
200--- Y
300--- A||B||C
400--- A||B
Concatination should be done in the SEQNO order.
I need an Idea to implement the following logic
Can any one suggest me
My Src seems like
ID---SEQNO---MSG
100--- 1--- X
200--- 1--- Y
300--- 1--- A
300--- 2--- B
300--- 3--- C
400--- 1--- A
400--- 2--- B
Output should be like
ID---- MSG
100--- X
200--- Y
300--- A||B||C
400--- A||B
Concatination should be done in the SEQNO order.