Solved
Deduplication Activity : how to use ´Or´ in the edit expression
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