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

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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