Regrouping data from data loading file

[gbernardin]

Hi, 

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

As 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 :

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 !

[Jonathon_wodnicki · Accepted solution]

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

[Sukrity_Wadhwa]

Hi @gbernardin,

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

Thanks