Comma separated column values

Toad Data Point
1

In Hyperion/BRIO, the following example is possible via pivot table.

In the following sample table,

ID

Col1

1

AAA

1

BBB

2

AAA

3

AAA

3

BBB

3

CCC

From the above results, I am interested in generating the following:

ID

Col1

1

AAA,BBB

2

AAA

3

AAA,BBB,CCC

In TDP, I tried pivoting characters, but it did not produce what I was looking for.

Is this possible in transform/cleanse? If so, what function should I use?

2

I don’t think that this can be archived by using transform/cleansing. But it can be done by using build in database functionalities.

Unfortunately the solution is server specific: for SQL Server you can use this example or the following article for Oracle.