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

Deduplication Activity : how to use ´Or´ in the edit expression

Avatar

Avatar
Validate 1
Level 1
KX00557965
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
KX00557965
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
KX00557965
Level 1

19-06-2018

Hi Everyone,

We have different deduplication rules to be applied in order to get the unique results.

We need to create a concatenated string for different fields and then compare those concatenated strings with a logical ´OR´.

contact(First_Name , Last_name) + RFC OR
contact(First_Name , Last_name) + email OR
contact(First_Name , Last_name) + phone OR
contact(First_Name , Last_name) + mobile OR
contact(First_Name , Last_name) + office_phone OR
mobile + email OR
phone + email OR

I have seen the ´OR´ can be applied when we are using the if statement however when we try to apply the above rules and put the logical OR it doesn't work.

Any information will be helpful.

dedup.jpg

Thanks

KR

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 250
Level 10
pablo_rosero1
Level 10

Likes

81 likes

Total Posts

348 posts

Correct Reply

77 solutions
Top badges earned
Validate 250
Validate 100
Validate 50
Validate 25
Validate 10
View profile

Avatar
Validate 250
Level 10
pablo_rosero1
Level 10

Likes

81 likes

Total Posts

348 posts

Correct Reply

77 solutions
Top badges earned
Validate 250
Validate 100
Validate 50
Validate 25
Validate 10
View profile
pablo_rosero1
Level 10

27-11-2018

Hi Kapil,

Try adding the different elements in the Filter Conditions window, before Edit the Expression.

Perhaps this can help: Parameterizing the Query in Adobe Campaign Classic |

All the best,

Pablo

Answers (0)