Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Merging of data while deduplicating

Avatar

Level 2

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

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

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

View solution in original post

1 Reply

Avatar

Correct answer by
Employee Advisor

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

Avatar

Level 2
@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