Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Unique values separated by comma

edited Aug 18, 2016 6:49AM in Reporting & Analytics for B2C Service 3 comments

Content

Hello,

I am trying to display a report that contains one row with unique values separated by comma.

My column looks like:

col_name
val1
val3
val1
val2
val2
val2

 

 

Report should show:

col_name: val1, val2, val3

Group Results is working but showing values in few rows. Group_Concat in column expression is also showing duplicates in one row...

Is it possible to achieve this?

 

 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!