Skip to main content
Level 2
Jun 13, 2024 12:48 PM UTC
Question

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

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

7 replies

ShashankNigam02
Adobe Employee
Adobe Employee
Jun 14, 2024 2:16 PM UTC

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/adding-additional-sql-functions

Translate
PawanGuAuthor
Level 2
Jun 14, 2024 2:44 PM UTC

Hi @shashanknigam02 ,

 

Thanks for reply 

 

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

 

 

 

Translate
ShashankNigam02
Adobe Employee
Adobe Employee
Jun 14, 2024 2:48 PM UTC

What error are you getting?

 

Translate
Level 3
Jun 17, 2024 1:55 AM UTC

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

 

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

Translate
PawanGuAuthor
Level 2
Jun 20, 2024 11:44 AM UTC

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 

Translate
Feb 20, 2025 3:32 PM UTC

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!

Translate