Expand my Community achievements bar.

SOLVED

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

Avatar

Level 1

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

1 Accepted Solution

Avatar

Correct answer by
Employee

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

View solution in original post

5 Replies

Avatar

Level 10

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

Avatar

Employee

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

Avatar

Level 1

Hi Adhiyan ,

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

Avatar

Correct answer by
Employee

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