Here is how to concatenate text from multiple rows into a single text string in Responsys SQL
in Responsys
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.
0