Regrouping data from data loading file | Community
Skip to main content
G
GuillaumeBE
November 3, 2020
Solved

Regrouping data from data loading file

  • November 3, 2020
  • 2 replies
  • 1243 views

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 !

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jonathon_wodnicki

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

2 replies

Jonathon_wodnicki
Community Advisor
Jonathon_wodnickiCommunity AdvisorAccepted solution
Community Advisor
November 9, 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

    Sukrity_Wadhwa
    Community Manager
    Sukrity_WadhwaCommunity Manager
    Community Manager
    November 17, 2020

    Hi @guillaumebe,

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

    Thanks

    Sukrity Wadhwa
    Terms & ConditionsAccessibility statement

    Loading footer...