Avatar

Level 1

Hi, 

 

I'm trying to regroup data coming from an external file on a same row using a unique ID. 

 

Capture_1.pngAs you can see, in the file I could have 2 or more unique ID on different rows with different products, price and quantity but with the same total amount.

 

How can I regroup those ID on the same row but with many product/price/quantity as row for the same ID ?

I try something like that but it doesn't works :

Capture_2.PNG

 

The final idea is to personalize an email for one customer with either product1 / quantity1 / price1 and if it's the case product2 / quantity2 / price 2, and so on using targetData and conditionnal content (if, else if, ...)

 

Hoping someone will be able to help me. 

 

Thanks,

GB

 

P.S: Sorry for my poor English !