Regrouping data from data loading file

Avatar

Avatar

gbernardin

Avatar

gbernardin

gbernardin

03-11-2020

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 !

Regrouping data from data loading file

Accepted Solutions (0)

Answers (2)

Answers (2)

Avatar

Avatar

Sukrity_Wadhwa

Employee

Avatar

Sukrity_Wadhwa

Employee

Sukrity_Wadhwa
Employee

17-11-2020

Hi @gbernardin,

Was the given solution helpful to resolve your query? Do let us know.

Thanks

Avatar

Avatar

wodnicki

MVP

Avatar

wodnicki

MVP

wodnicki
MVP

09-11-2020

Hi,

 

Query ----------\
                 Enrichment ----- Delivery
File import ----/

 

In the enrichment, set primary set Query, join cardinality 1:n, and specify max number of products to expect (rows to pivot).

If max number of products is unknown, you'll have to write JS to sort it out.

 

Thanks,

-Jon