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

gaëlm35210402

03-12-2018

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).

1638023_pastedImage_1.png

Accepted Solutions (1)

Accepted Solutions (1)

Adhiyan

Employee

06-12-2018

Hello Gael,

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

1640345_pastedImage_0.png

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

Regards,
Adhiyan

Answers (4)

Answers (4)

Adhiyan

Employee

05-12-2018

Hi Gael,

You can add a deduplication before you upload the data.

The workflow should look like this.

1639641_pastedImage_0.png

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

1639652_pastedImage_2.png

Regards,
Adhiyan