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
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Check Email Existence in Profiles

YoussefC
Level 1
Level 1

Hey,

I have this amateur question about checking if an email exists:

Now, I have a file containing some emails, I load it, but there some emails that already exist in the Profiles table, so I want to update the existing ones, while inserting the new ones with extra and different data,

I used Reconciliation Activity which indeed returned the existing Emails but while using the option "Keep in the outbound population" seems to keep everything and does not have an option like Segmentation to generate a Complement.

Any ideas,

Thank you

1 Accepted Solution
ParthaSarathy
Correct answer by
Level 5
Level 5

Hi @YoussefC ,

Lets consider your file has 10 profile data, where 5 profile already exist in database, and another 5 are new.

When you do enrichment/reconciliation, you said the output had all 10 records. When you analyse the data from output  transition of Reconciliation activity, you can figure out 5 existing profile will have primary key number, whereas new records will have primary key @id as 0. So after this Reconciliation you can use a segmentation activity and you can separate this records and perform your update activity.

Regards,

ParthaSarathy S

View solution in original post

1 Reply
ParthaSarathy
Correct answer by
Level 5
Level 5

Hi @YoussefC ,

Lets consider your file has 10 profile data, where 5 profile already exist in database, and another 5 are new.

When you do enrichment/reconciliation, you said the output had all 10 records. When you analyse the data from output  transition of Reconciliation activity, you can figure out 5 existing profile will have primary key number, whereas new records will have primary key @id as 0. So after this Reconciliation you can use a segmentation activity and you can separate this records and perform your update activity.

Regards,

ParthaSarathy S

View solution in original post