Hi community, I have two tables the first one named Annonce and the secound one trending, the first one it contain all the announces that a profile make in our website and its linked to the profile table, so we need to make a delivery with 15 trend products based on the second table that has the category, keyword and the price for the 15 products. So to make a collection we are liked the announce table with trending table based on a comun field named @category but the issue that we face is that we can't get all the categorites in the transition we get only those wich match the category in the announce table for every profile and we need to get all the categories for all the profile not only the ones in common.
In fact we can't link the tables with another field cuz we don't have too much fileds in trending table.
Have query activity that will identify your targets which has announces linked with profile and on the additional data create collection to retrieve 1 record that links to announce table then specify the fields from trending table (based on the link trending -> announces) you want to carry further down on the workflow.
Use deduplication activity and set the maximum records to allow for same email.
You can use enrichment activity with N collection link and on the additional data section create collection to retrieve "n" (specify max. products to be displayed on the email) records that will pull details from trending table fields.
This will give you all the trending table product data into single row and apply deduplication activity to keep one record for email and use the personalization to pull the information from additional data to specify on the delivery.
Note: This is based on understanding you have link from announces table to profile and trending table to announces.