# Comma separated column values

**URL:** <https://forums.toadworld.com/t/comma-separated-column-values/27331>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [October 27, 2013, 1:54pm UTC](https://forums.toadworld.com/t/comma-separated-column-values/27331 "2013-10-27T13:54:09Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![TDP\_OWL](https://avatars.discourse-cdn.com/v4/letter/t/ce73a5/32.png) [@TDP\_OWL](https://forums.toadworld.com/u/TDP_OWL)\
**Post date:** [October 27, 2013, 1:54pm UTC](https://forums.toadworld.com/t/comma-separated-column-values/27331/1 "2013-10-27T13:54:09Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![AlekseyBazhenov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@AlekseyBazhenov](https://forums.toadworld.com/u/AlekseyBazhenov)\
**Post date:** [October 28, 2013, 8:01am UTC](https://forums.toadworld.com/t/comma-separated-column-values/27331/2 "2013-10-28T08:01:02Z")

</div>

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](http://www.mssqltips.com/sqlservertip/2914/rolling-up-multiple-rows-into-a-single-row-and-column-for-sql-server-data/) or the following [article](http://www.oracle-base.com/articles/misc/string-aggregation-techniques.php)for Oracle.
