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

Getting counts of records coming from an enrichment activity in ACS

Avatar

Avatar
Level 1
chetan01
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
chetan01
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
View profile
chetan01
Level 1

25-09-2020

I want to get the total counts of records (preferably in a variable) coming out from an enrichment activity (let's call it enrichment A) which I then want to use in my subsequent activities downstream ( let's call it enrichment B) .

 

In my enrichment B activity I actually use a case / iif with this variable. The problem is count all etc is not supported in enrichment so I am thinking the only way would be to get the total count of records coming into enrichment B through a variable. 

 

Do let me know if any ideas/ suggestions on this. 

Thanks

Adobe Campaign Standard count enrichment

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 250
Employee
ramon_bisswanger
Employee

Likes

266 likes

Total Posts

392 posts

Correct Reply

192 solutions
Top badges earned
Boost 250
Affirm 100
Give Back 25
View profile

Avatar
Boost 250
Employee
ramon_bisswanger
Employee

Likes

266 likes

Total Posts

392 posts

Correct Reply

192 solutions
Top badges earned
Boost 250
Affirm 100
Give Back 25
View profile
ramon_bisswanger
Employee

29-09-2020

In ACS unfortunately you can't define a variable for this.

Though the default variable recCount should be available for this.

Or you might use following approach:

  • Use the below function to count the row number 
  • Afterwards you can do a Deduplication step.
    If you choose to deduplicate by keeping the record with the highest row number, you would have 1 row in the result containing the row count.
RowNum(PartitionBy(<Value 1>), OrderBy(<Value 2>))​

Answers (0)