Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Getting Duplicate Results Using Group_Concat - Help! — Cloud Customer Connect
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

Getting Duplicate Results Using Group_Concat - Help!

Received Response
edited Jun 19, 2015 3:17PM in Reporting & Analytics for B2C Service 5 comments


Hi there and thanks for looking!

I'm trying to return all names of answer attachments into one row per answer using the expression:

group_concat( fattach.userfname,' , ')

But the results show duplicates of each attachment name. />

I tried using distinct here: group_concat(distinct fattach.userfname,' , ') but the system wouldn't accept that. What am I missing? I attached the report definition. Any help is much appreciated!


Amanda Balliet


Howdy, Stranger!

Log In

To view full details, sign in.


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