Merging of data while deduplicating

[sebastianm66451]

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:

email	download
test@test.com	Paper 1
test@test.com	Paper 2

Into: 

email	download
test@test.com	Paper 1, Paper 2

Thank you in advance!

Best regards,

Sebastian

[ramon_bisswanger · Accepted solution]

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

[sebastianm66451]

@ramon_bisswanger - 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