BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

How to do a Cross field matching between different records ?


 
Search this topic... | Search DI: Data Quality... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Data Quality  Previous TopicPrint TopicNext Topic
Author Message
Davidkrn
Forum Member
Forum Member



Joined: 03 Oct 2013

Posts: 12



PostPosted: Thu Feb 21, 2019 8:09 pm 
Post subject: How to do a Cross field matching between different records ?

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

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.

Thanks,
Dave
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Data Quality  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0290 seconds using 17 queries. (SQL 0.0029 Parse 0.0008 Other 0.0252)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo