group by clause in adobe campaign standard | Community
Skip to main content
P
pushpad15690171
Level 2
January 9, 2020
Solved

group by clause in adobe campaign standard

  • January 9, 2020
  • 1 reply
  • 8262 views

I have a use case to count all the recipient in database in ACS and print it over the email .

 

But i am not able to do it using count aggregate function in addtional data as it is giving the error , to group by .

 

But there is no group by option in ACS ,is there a way we can complete this usecase.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Amit_Kumar

Hi follow given steps:

 

1. add a false collection to your base query using additional data.

 

2. add enrichment to compute your aggregates:

3. in your enrichment go to Advanced Relations tab and add a relation to your collected added in the previous query using the @collectionLink as the source and destination expression.

4. Using additional data in enrichment add your aggregates:

now you can use this CountRecords in your email using personalisation field.

 

Regards,

Amit

 

 

 

 

1 reply

Amit_Kumar
Amit_KumarAccepted solution
Level 10
January 17, 2020

Hi follow given steps:

 

1. add a false collection to your base query using additional data.

 

2. add enrichment to compute your aggregates:

3. in your enrichment go to Advanced Relations tab and add a relation to your collected added in the previous query using the @collectionLink as the source and destination expression.

4. Using additional data in enrichment add your aggregates:

now you can use this CountRecords in your email using personalisation field.

 

Regards,

Amit

 

 

 

 

    P
    pushpad15690171Author
    Level 2
    January 20, 2020
    Thanks Amit, have followed the same and was able to acheive it.......
    Terms & ConditionsAccessibility statement

    Loading footer...