Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

group by clause in adobe campaign standard

pushpad15690171
Level 2
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
Amit_Kumar
Correct answer by
Community Advisor
Community Advisor

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

1 Reply
Amit_Kumar
Correct answer by
Community Advisor
Community Advisor

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

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