Hi All,
I just need some suugestions to acheive the following logic.
ID VALUE
1 A
2 A
2 B
2 C
3 A
3 B
4 A
The output should be something like
ID VALUE
1 A
2 A|B|C
3 A|B
4 A
the values should be concatenated together if they have same ID.
Any suggestions would be greatly helpful.
Regards
Kumar
Logic Help in 7.5
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 60
- Joined: Tue Sep 20, 2011 10:44 pm
- Location: INDIA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
That looks like a simple vertical pivot (a following Column Export stage would pack the columns into a single column). What have you tried? We're not really in the business of being the developer you're pretending to be.
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.
-
- Premium Member
- Posts: 376
- Joined: Sat Jan 07, 2012 12:25 pm
- Location: Piscataway
If your source resides in an Oracle database, you can use the function WM_CONCAT.
Jerome
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.