How to add linebreaks as delimiter to the concat function?

[andy]

Hi folks,

I'm playing around with the concat aggregation-function and would like to have a linebreak as the delimiter.

After all the trial and error I can think of I still have no success.

The example below just prints \r\n as the delimiter in the pivottable-cell....

Any suggestion on how to do this?

 LOAD
 ID,
 concat(DISTINCT PRODNAME,'\r\n') as PRODNAME_STR
 RESIDENT PRODNAME_tmp2 GROUP BY ID;

brgds

Andy

[#2 · Accepted solution]

Hi Andy

Not sure if this will work, but you could try:

concat(DISTINCT PRODNAME, chr(13)) AS PRODNAME_STR

Let me know if it works,