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!

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

Content

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!

Thanks,

Amanda Balliet

IBM

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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