Expand my Community achievements bar.

SOLVED

group by clause in adobe campaign standard

Avatar

Level 2

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.

1 Accepted Solution

Avatar

Correct answer by
Level 10

Hi follow given steps:

 

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

 

Amit_Kumar_0-1579260716757.png

Amit_Kumar_1-1579260760620.png

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.

Amit_Kumar_2-1579260921441.png

4. Using additional data in enrichment add your aggregates:

Amit_Kumar_3-1579261007080.png

Amit_Kumar_4-1579261051628.png

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

 

Regards,

Amit

 

 

 

 

View solution in original post

2 Replies

Avatar

Correct answer by
Level 10

Hi follow given steps:

 

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

 

Amit_Kumar_0-1579260716757.png

Amit_Kumar_1-1579260760620.png

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.

Amit_Kumar_2-1579260921441.png

4. Using additional data in enrichment add your aggregates:

Amit_Kumar_3-1579261007080.png

Amit_Kumar_4-1579261051628.png

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

 

Regards,

Amit

 

 

 

 

Avatar

Level 2
Thanks Amit, have followed the same and was able to acheive it.......