Skip to Content
0
Former Member
Aug 05, 2010 at 01:43 PM

Group field to comma separated String

341 Views

Hi

Using BODS, I'm trying to go from

+---+---+
| C | N |
+---+---+
| a | 1 |
| a | 2 |
| a | 3 |
| b | 2 |
| b | 4 |
+---+---+

to

+---+-------+
| C |  f(N) |
+---+-------+
| a | 1,2,3 |
| b |   2,4 |
+---+-------+

Meaning, it should group using the column C and have as another column the concatenation of column N separated with commas.

In another word, I would like to do the opposite of this : [split a comma separated String into multiple rows|http://wiki.sdn.sap.com/wiki/pages/viewpage.action?pageId=49414399]

I tried but so far no luck in doing so. Have someone have an idea?

Regards