How to get the most ordered product via adobe campaign ?

Avatar

Avatar

oliviergroux

Avatar

oliviergroux

oliviergroux

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

Sukrity_Wadhwa

Employee

Avatar

Sukrity_Wadhwa

Employee

Sukrity_Wadhwa
Employee

12-10-2020

Hi @oliviergroux,

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

Thanks!