Get records count | Community
Skip to main content
M
mak_007
September 1, 2020
Question

Get records count

  • September 1, 2020
  • 2 replies
  • 1756 views

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 

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

Milan_Vucetic
Milan_Vucetic
Level 9
September 1, 2020

Hi @mak_007,

add one more Enrichment node and set these:

Regards,

Milan

M
mak_007Author
September 1, 2020
@2897273_Vecetic I tried but i am getting a error when i click on display results .Postgresql error:column w0.count1 does not exist .
    Sukrity_Wadhwa
    Community Manager
    Sukrity_WadhwaCommunity Manager
    Community Manager
    October 1, 2020

    Hi @mak_007,

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

    Thanks!

    Sukrity Wadhwa
    Terms & ConditionsAccessibility statement

    Loading footer...