Logic Help in 7.5

[phanikumar]

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

[ray.wurlod]

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.

[jerome_rajan]

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