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

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)

Answers (0)