Join our Community in its new Home - The Datorama Trailblazer Community Group!
It's been an amazing 3 years coming together in this forum to collaborate, innovate, support, and inspire each other about our shared usage of Datorama. While this is not quite a goodbye, we are excited to announce that we are getting a fresh start in our new home within the Salesforce Trailblazer Community. We have a ton of fun new content planned and you may even see the revival of some of our most popular posts from the past few years.
We’ll be keeping this group around for a bit for you to peruse, but as of November 15, we will no longer be allowing new posts or comments. Be sure to join our new group at https://www.salesforce.com/success-datorama to keep the conversation going.
We can’t wait to see you there!
It's been an amazing 3 years coming together in this forum to collaborate, innovate, support, and inspire each other about our shared usage of Datorama. While this is not quite a goodbye, we are excited to announce that we are getting a fresh start in our new home within the Salesforce Trailblazer Community. We have a ton of fun new content planned and you may even see the revival of some of our most popular posts from the past few years.
We’ll be keeping this group around for a bit for you to peruse, but as of November 15, we will no longer be allowing new posts or comments. Be sure to join our new group at https://www.salesforce.com/success-datorama to keep the conversation going.
We can’t wait to see you there!
Unnest two columns
Marie
FranceACCOUNT_ADMIN 
in Help Center
Hello,
I'm trying to split product names' column coming from my floodlight adserver report. One cell might have several product for one adserver conversion.
The Unnest transformer helped me to split this column into several rows.
And then, the measurements are recalculated with the "Unnest" column value :
But the problem then is that the revenue is not proportionnal to the number of product but their values. And for this, I also have the price of each product in the same order. But if I use the transformer a second time, several prices get associated with one product.
Does anyone has already face this kind of issue, and how did you deal with it ?
How can I reattribuate the right price to my products ? Can I do it through Datorama ? Or should I use an intermediate ?
Thank you for you help !
I'm trying to split product names' column coming from my floodlight adserver report. One cell might have several product for one adserver conversion.
The Unnest transformer helped me to split this column into several rows.
And then, the measurements are recalculated with the "Unnest" column value :
But the problem then is that the revenue is not proportionnal to the number of product but their values. And for this, I also have the price of each product in the same order. But if I use the transformer a second time, several prices get associated with one product.
Does anyone has already face this kind of issue, and how did you deal with it ?
How can I reattribuate the right price to my products ? Can I do it through Datorama ? Or should I use an intermediate ?
Thank you for you help !
Tagged:
Comments
Thank you for your interesting question.
We have an article on the topic:
https://support.datorama.com/en/support/solutions/articles/4000083943-unnest-transformer
If it is not sufficient, please log a ticket to our team at [email protected]
and we will be able to look in detail.