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
BedrockMission!

Learn more

View all

Sign in to view all badges

Get records count

mak_007
Level 1
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 

 

 

Adobe Campaign Classic
5 Replies
Milan_Vucetic
Community Advisor
Community Advisor

Hi @mak_007,

add one more Enrichment node and set these:

Milan_Vucetic_0-1598965789736.png

Regards,

Milan

mak_007
Level 1
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 .
Milan_Vucetic
Community Advisor
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

Sukrity_Wadhwa
Employee
Employee

Hi @mak_007,

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

Thanks!