How to use string aggregate inside enrichment for merge rows data to single row with colon separator?

[PawanGu]

I am using StringAgg(<value>,";") but is giving error when run campaign. Anybody tell me correct syntax.

[ShashankNigam02]

Hi @PawanGu , Looks like you are using a SQL function which is not available OOTB. Please go through the below documentation to add your SQL function and use the same withing a workflow activity.

https://experienceleague.adobe.com/en/docs/campaign-classic/using/configuring-campaign-classic/api/a...

[PawanGu]

Hi @ShashankNigam02 ,

Thanks for reply 

I am using list of functions inside the enrichment. But this is giving error. See below:

[ShashankNigam02]

What error are you getting?

[PawanGu]

Hi @ShashankNigam02 ,

Error: "StringAgg": invalid identifier.

[vt0509]

Hi @PawanGu , you can use this function too, works for Concatenating multiple string values.

CONCAT(<string1>,'<separator>',<string2>)

[PawanGu]

Hi @vt0509 , I wan to concat single column multirow value to single row with separator. See below:

Input

Column A

123

456

789

Output

Column A

123;456;789 

[noelani]

Were you able to find a solution for your problem?
I am trying to do the same and get the same error message.

Thank you in advance!