Check Email Existence in Profiles | Community
Skip to main content
J
joe_17382226
Level 2
September 21, 2020
Solved

Check Email Existence in Profiles

  • September 21, 2020
  • 1 reply
  • 1520 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by ParthaSarathy

Hi @joe_17382226 ,

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

1 reply

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
September 21, 2020

Hi @joe_17382226 ,

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

~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
    Terms & ConditionsAccessibility statement

    Loading footer...