I'm trying to create an email that provides sellers on a website with a breakdown of sales they have made the previous day.
We have a data extension we will be sending to, and a data extension we need to pull the content from. They are related by a shared user ID value, but the latter table is 1:many, as the user can sell multiple items (1 row per item). We therefore need to concatenate all possible values associated with a user ID - to be ordered alphabetically.
I tried something like this, but I think I'm way off:
<!--%%[SET @UID = [User_ID]]%% -->
<!--%%[
SET @Rows = LookupRows("DAILY SALES DE","User_ID",@UID)
IF RowCount(@Rows) > 0 THEN
SET @resource_name = FIELD(ROW(@Rows,1),"resource_name")
SET @store_purchases = FIELD(ROW(@Rows,1),"store_purchases")
THEN DO
SET @resource_list = "<li style='border-bottom: 1px solid #ebeced;'>%%=v(resource_name)=%%<span style='font-style:italic; font-weight:400; color:5c656e;'> %%=v(@store_purchases)=%%</span></li>"
ELSE
SET @resource_list = " "
ENDIF
]%% -->
The AMPscript within AMPscript is a problem here, as it doesn't display properly.
I'm sure I'm going about this the wrong way however; is there an easy way to concatenate all the associated values from the content data extension and display them as list items specified above?
Any info would be greatly appreciated.