Merging of data while deduplicating

sebastianm66451

18-06-2020

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

Accepted Solutions (1)

Accepted Solutions (1)

ramon_bisswange

Employee

21-06-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

Answers (0)