Expand my Community achievements bar.

SOLVED

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

Avatar

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

Avatar

Correct answer by
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

Avatar

Correct answer by
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