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.
Concatination
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Use a downstream Remove Duplicates stage to pass only the last in each group.
Or upgrade to version 8.5 where you can do loop processing within the Transformer stage.
Or upgrade to version 8.5 where you can do loop processing within the Transformer stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.