How to use string aggregate inside enrichment for merge rows data to single row with colon separator? | Community
Skip to main content
P
PawanGu
Level 2
June 13, 2024
Question

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

  • June 13, 2024
  • 2 replies
  • 1624 views

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

2 replies

ShashankNigam02
Adobe Employee
ShashankNigam02Adobe Employee
Adobe Employee
June 14, 2024

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

P
PawanGuAuthor
Level 2
June 14, 2024

Hi @shashanknigam02 ,

 

Thanks for reply 

 

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

 

 

 

ShashankNigam02
Adobe Employee
ShashankNigam02Adobe Employee
Adobe Employee
June 14, 2024

What error are you getting?

 

V
vt0509
Level 3
June 17, 2024

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

 

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

P
PawanGuAuthor
Level 2
June 20, 2024

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 

N
noelani
February 20, 2025

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!

Terms & ConditionsAccessibility statement

Loading footer...