Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Regrouping data from data loading file

gbernardin
Level 1
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 !

Regrouping data from data loading file
1 Accepted Solution
wodnicki
Correct answer by
Community Advisor
Community Advisor

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

View solution in original post

2 Replies
wodnicki
Correct answer by
Community Advisor
Community Advisor

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

View solution in original post

Sukrity_Wadhwa
Employee
Employee

Hi @gbernardin,

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

Thanks