Merging of data while deduplicating | Community
Skip to main content
S
Sebastiancm1
Level 2
June 19, 2020
Solved

Merging of data while deduplicating

  • June 19, 2020
  • 1 reply
  • 1580 views

Hi all,

I have a case where I want to deduplicate some data on the email in order to only have unique profiles in the dataset. However, on one field I would like to keep the data for all the cases as I need to keep all the information. 

Is it possible to keep only one unique profile and at the same time keep all the data in one field so we can export it and have a overview of all downloads on one profile. 

So as an example, this is how I would like it to be transformed: 

From:

emaildownload
test@test.comPaper 1
test@test.comPaper 2

Into: 

emaildownload
test@test.comPaper 1, Paper 2

 

Thank you in advance!

 

Best regards,

Sebastian

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 bisswang

You can't do that directly in the Deduplication task.

Though what you may do:

* Enable Complement on the Dedupication activity

* Then use an Enrichment to "join" the 2 outputs from Deduplication based on the wanted key

* Then you can define it as 0..1 / n-collection join and fetch the additional download infos

1 reply

B
Adobe Employee
bisswangAdobe EmployeeAccepted solution
Adobe Employee
June 22, 2020

You can't do that directly in the Deduplication task.

Though what you may do:

* Enable Complement on the Dedupication activity

* Then use an Enrichment to "join" the 2 outputs from Deduplication based on the wanted key

* Then you can define it as 0..1 / n-collection join and fetch the additional download infos

S
Sebastiancm1Author
Level 2
June 22, 2020
@bisswang - thank you. I tried it and it works fine this way. I was hoping to have a way to do this without having to make a lot of deduplication activities but it is fine for now. Thank's again. /sebastian
Terms & ConditionsAccessibility statement

Loading footer...