group by clause in adobe campaign standard

[#1]

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.

[pushpad15690171 · Accepted solution]

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

[pushpad15690171 · Accepted solution]

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