Here is how to concatenate text from multiple rows into a single text string in Responsys SQL

Hope this will help you save few hours that i spent figuring out which function is supported in Responsys to concatenate text form multiple rows into a single text string, while ensuring there are no duplicates

Responsys SQL does not support: DISTINCT, GROUP_CONCAT () nor STRING_AGG ()

However Responsys does support LISTAGG () function and DISTINCT can be implemented manually by removing duplicates before aggregation—e.g. in a subquery.

The following example demonstrates this approach. The columns g and o represent the group by and order by keys respectively. The example uses min(o) to keep the first occurrence in case one value appears multiple times.