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

Getting counts of records coming from an enrichment activity in ACS

Avatar

Level 1

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

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

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>))​

View solution in original post

3 Replies

Avatar

Level 2
Try this $long(vars/@recCount) it will give the total of records

Avatar

Correct answer by
Employee Advisor

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>))​