Expand my Community achievements bar.

SOLVED

Getting counts of records coming from an enrichment activity in ACS

Avatar

Level 2

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

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