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
BedrockMission!

Learn More

View all

Sign in to view all badges

group by clause in adobe campaign standard

Avatar

Avatar
Validate 1
Level 1
pushpad15690171
Level 1

Likes

2 likes

Total Posts

10 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 1
pushpad15690171
Level 1

Likes

2 likes

Total Posts

10 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
pushpad15690171
Level 1

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)

Avatar

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile
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)