Get records count

[#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 

[#2]

Hi @mak_007,

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

Thanks!

[mak_007]

Hi @mak_007,

add one more Enrichment node and set these:

Regards,

Milan

[mak_007]

Please find below.

[mak_007]

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

[Milan_Vucetic]

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