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

[KX00557965]

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.

Thanks

KR

[pablo_rosero1 · Accepted solution]

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