Hi,
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
[b]Name, Phone1, Phone2, Phone3
David, 1234, 6789, 4444
Dave, 6666, 1234, 7777[/b]
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.
Thanks,
Dave
Davidkrn (BOB member since 2013-10-03)