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

The 4th edition of the Campaign Community Lens newsletter is out now!

Get records count


Level 1

Hi Experts,


In my workflow i have recipients linked to purchase history table 1-n and each purchaseId has many records in items table.Now i want to get count of number of items present for each purchaseId

I have linked purchase table to items table  1-n in enrichment but  i am not able get the count of  items for each each purchaseId.


could any one let me know how to implement this .





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

5 Replies


Community Advisor

Hi @mak_007,

add one more Enrichment node and set these:





Level 1
@milan_Vecetic I tried but i am getting a error when i click on display results .Postgresql error:column w0.count1 does not exist .


Community Advisor

Hi @mak_007, you must provide more information or screenshoot of what you maked. Provided aggregation will work for described problem but we cannot see what or how you created everything. Regards, Milan



Hi @mak_007,

Were you able to resolve this query with the given solution? Please let us know.