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

Get records count

Avatar

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 .

@Milan_Vucetic 

 

 

Topics

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

3 Replies

Avatar

Community Advisor

Hi @mak_007,

add one more Enrichment node and set these:

Milan_Vucetic_0-1598965789736.png

Regards,

Milan

Avatar

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 .

Avatar

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

Avatar

Administrator

Hi @mak_007,

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

Thanks!