How to verify if a user is already in our DB and avoid to register him twice ? | Community
Skip to main content
December 3, 2018
Solved

How to verify if a user is already in our DB and avoid to register him twice ?

  • December 3, 2018
  • 5 replies
  • 2475 views

Hi everyone,

Could you help me with a basic option (I think). In fact I have a landing page where you could add your name, LN, email adresse and company name.
After that you are just registered in our database.

I would like to avoid duplicate users (based on their email adress, first and lastname).

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 Adhiyan

Hello Gael,

In that case , simply select  the operation as INSERT in the Update data activity (Database /newcomers for you) .

If you try to enter a email ID already present , it would throw an error .

Regards,
Adhiyan

5 replies

pablo_rosero1
Level 9
December 3, 2018

Hi Gael,

Good question! Moving this to the Adobe Campaign Classic forum for follow up since this forum is for Campaign Standard only.

All the best,

Pablo

pablo_rosero1
Level 9
December 5, 2018
Adhiyan
Adobe Employee
Adobe Employee
December 5, 2018

Hi Gael,

You can add a deduplication before you upload the data.

The workflow should look like this.

Inside the deduplication , you choose the columns where you want to deduplicate

Regards,
Adhiyan

December 5, 2018

Hi Adhiyan ,

The think is this workflow is in a Web Application so I'm not able to use the "deduplication"

Adhiyan
Adobe Employee
AdhiyanAdobe EmployeeAccepted solution
Adobe Employee
December 6, 2018

Hello Gael,

In that case , simply select  the operation as INSERT in the Update data activity (Database /newcomers for you) .

If you try to enter a email ID already present , it would throw an error .

Regards,
Adhiyan