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

How to get the most ordered product via adobe campaign ?

Avatar

Avatar
Validate 1
Level 1
oliviergroux
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
oliviergroux
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
oliviergroux
Level 1

02-10-2020

Hi Adobe Community!

 

I'm trying to get the product most ordered by a customer based on the below table:

oliviergroux_0-1601655881737.png

 

What I'm trying to achieve is to get a final table with Cus_ID | Most ordered 

Ex with the above:

Cus_ID             |  Most ordered 

677210000124 |  1,421

 

The main table is the Recipient table and the other table is linked via a "one to many" link.

What should I do to get to this outcome?

 

Thanks in advance,

Olivier

View Entire Topic

Avatar

Avatar
Validate 500
Employee
Sukrity_Wadhwa
Employee

Likes

131 likes

Total Posts

804 posts

Correct Reply

35 solutions
Top badges earned
Validate 500
Validate 250
Validate 100
Validate 25
Validate 50
View profile

Avatar
Validate 500
Employee
Sukrity_Wadhwa
Employee

Likes

131 likes

Total Posts

804 posts

Correct Reply

35 solutions
Top badges earned
Validate 500
Validate 250
Validate 100
Validate 25
Validate 50
View profile
Sukrity_Wadhwa
Employee

12-10-2020

Hi @oliviergroux,

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

Thanks!