Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

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

gaëlm35210402
Level 1
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
Adhiyan
Correct answer by
Employee
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
pablo_rosero1
Level 10
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

Adhiyan
Employee
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

gaëlm35210402
Level 1
Level 1

Hi Adhiyan ,

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

Adhiyan
Correct answer by
Employee
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