DSXchange

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

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.

If your source resides in an Oracle database, you can use the function WM_CONCAT.