I've got a (simplified) with 3 columns: Offer_name / Product_Name/ Offer_rating
I want to display, thanks to AMPScript, the best rated offered in my newsletter. However, I do not want to display a Product_Name twice.
I used the "de-duplicate row" code by https://sprignaturemoves.com/de-duplicate-rows-ampscript/
But instead of ordering my rows by Product_Name, I have to do it by Offer_rating
The results is that I can have the same Product_Name displayed several times in my email.
This is because only the prevproductname is stored and I would need to store prevproductname1, prevproductname2, etc.
doesn't seem to work so I am a little stuck there.
Does any body had had the same issue?
Here are a sample of data ordered by offer_rating :