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

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

KX00557965
Level 1
Level 1

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

1 Accepted Solution
pablo_rosero1
Correct answer by
Level 10
Level 10

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

View solution in original post

1 Reply
pablo_rosero1
Correct answer by
Level 10
Level 10

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

View solution in original post