group by clause in adobe campaign standard

pushpad15690171

08-01-2020

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.

Accepted Solutions (1)

Accepted Solutions (1)

Amit_Kumar

MVP

17-01-2020

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

 

 

 

 

Answers (0)