Skip to Content

How to do a Cross field matching between different records using Match Transform?


I'm trying to do a cross field matching between different records in a group.

For instance, consider below records with phone numbers, where I'm trying

Name, Phone1, Phone2, Phone3

David, 1234, 6789, 4444

Dave, 6666, 1234, 7777

The above two records should be matching as Phone1 in first record and Phone2 in second record match.

I tried with "Multiple field comparisons" in the Base_Match transform. But its not giving expected result as it only gives matching if Phone1 in both records matches.

Can anyone please help.


Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Feb 22, 2019 at 12:49 PM

    Hello Dave,

    Please check out KBA 1323629 and KBA 1323656. Based on your explanation it sounds like you may be using the 'same field to other records' option instead of the 'all selected fields in other records' option.


    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 23, 2019 at 12:32 AM

    Hi Brandon,

    Thanks for the reply. I tried both the options. But it gives inconsistent results both times.

    What I did was, I added "Phone1" in the "Criteria Fields" section; and in the "Multiple Field Comparisons" section I pulled "Phone2" with selecting option "all selected fields in other records".

    Even I tried with adding both Phone1 and Phone2 in "Multiple Field Comparisons" section.



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.