Check Email Existence in Profiles

Avatar

Avatar
Validate 1
Level 1
YoussefC
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
YoussefC
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
YoussefC
Level 1

21-09-2020

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Affirm 5
Level 4
ParthaSarathy
Level 4

Likes

42 likes

Total Posts

66 posts

Correct reply

30 solutions
Top badges earned
Affirm 5
Establish
Give Back
Boost 5
Boost 3
View profile

Avatar
Affirm 5
Level 4
ParthaSarathy
Level 4

Likes

42 likes

Total Posts

66 posts

Correct reply

30 solutions
Top badges earned
Affirm 5
Establish
Give Back
Boost 5
Boost 3
View profile
ParthaSarathy
Level 4

21-09-2020

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

Answers (0)