Getting counts of records coming from an enrichment activity in ACS

Question

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

bisswang · Accepted Answer

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

Ghanname · Answer

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

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded