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

Avatar

Avatar

KX00557965

Avatar

KX00557965

KX00557965

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

pablo_rosero1

Avatar

pablo_rosero1

pablo_rosero1

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)