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

Regrouping data from data loading file

Avatar

Avatar
Validate 1
Level 1
gbernardin
Level 1

Like

1 like

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Ignite 1
Give Back 3
Give Back
Boost 1
View profile

Avatar
Validate 1
Level 1
gbernardin
Level 1

Like

1 like

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Ignite 1
Give Back 3
Give Back
Boost 1
View profile
gbernardin
Level 1

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 (1)

Accepted Solutions (1)

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

958 likes

Total Posts

1,079 posts

Correct Reply

506 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

958 likes

Total Posts

1,079 posts

Correct Reply

506 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
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

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1000
Employee
Sukrity_Wadhwa
Employee

Likes

140 likes

Total Posts

856 posts

Correct Reply

35 solutions
Top badges earned
Validate 1000
Validate 500
Validate 250
Validate 100
Validate 25
View profile

Avatar
Validate 1000
Employee
Sukrity_Wadhwa
Employee

Likes

140 likes

Total Posts

856 posts

Correct Reply

35 solutions
Top badges earned
Validate 1000
Validate 500
Validate 250
Validate 100
Validate 25
View profile
Sukrity_Wadhwa
Employee

17-11-2020

Hi @gbernardin,

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

Thanks