COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: camjam980 on 21 Sep 2015 04:11:12 PM

Title: Concatenate a field based on grouping of another field
Post by: camjam980 on 21 Sep 2015 04:11:12 PM
I have a report I'm trying to create that would have a list of expense reports and the attendees that were present. I'm trying to see if I can concatenate the attendees into a string delimited by comments based on the report ID to use as a field for a column of the report.

Are there any functions which can concatenate a field of values separated by a character? Similar to java's String.join(',', array);