Matchcode Optimization:Blank Matching: Difference between revisions
Created page with "Placeholder Page *Matchcode Optimization:First Component *Matchcode Optimization:Fuzzy Algorithms *Matchcode Optimization:Swap Matching *[[Matchcode Optimization:..." |
No edit summary |
||
(11 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
{{MatchcodeOptimizationNav | |||
|MatchcodeOptimizationCollapse= | |||
}} | |||
*[[ | ==Blank Matching== | ||
===Specifics=== | |||
*[[MatchUp Object:Blank Field Matching|Blank Field Matching]] | |||
===Summary=== | |||
Sometimes it is desirable to create a matchcode that will prevent matches when two compared values are present and unique, but allow the match when one of the values is blank or an initial abbreviation. Enabling Short/Empty options determine blank value behavior. | |||
===Returns=== | |||
A match if the value is the same, or if its blankness or initial satisfies the configured match conditions. | |||
===Example Matchcode Usage 1=== | |||
:[[File:MCO_Algorithm_BlankMatching_ShortApt.png|link=]] | |||
===Example Data 1=== | |||
{{ExampleDataTableV1|FIRST|LAST|RESULT | |||
|AdditionalRows= | |||
{{EDTRow|Green|John|Smith|Match Found}} | |||
{{EDTRow|Green|J|Smith|Match Found}} | |||
{{EDTRow|Green| |Smith|Match Found}} | |||
{{EDTRow|Red|Mary|Smith|Unique}} | |||
}} | |||
===Example Matchcode Usage 2=== | |||
:[[File:MCO_Algorithm_BlankMatching_ShortName.png|link=]] | |||
===Example Data 2=== | |||
{{ExampleDataTableV1|LAST|ADDRESS|RESULT | |||
|AdditionalRows= | |||
{{EDTRow|Green|Smith|12 Main St apt 3|Match Found}} | |||
{{EDTRow|Green|Smith|12 Main St|Match Found}} | |||
{{EDTRow|Red|Smith|12 Main St apt 2|Unique}} | |||
{{EDTRow|Green|Smith|12 Main St|Match Found}} | |||
}} | |||
In both of the above examples, the unmatched record could have been found as (and indeed could be) a match to one of the other ‘one-blank’ records. But the previously processed short record had already been placed into another duplicate group. | |||
{{MatchcodePerformance | |||
|Performance4= | |||
|Matches3= | |||
}} | |||
===Recommended Usage=== | |||
Hybrid deduper, where a single incoming record can quickly be evaluated independently against each record in an existing large master database. | |||
Small batch runs where the actual number of blank values is minimal. | |||
===Not Recommended For=== | |||
Batch processes where the number of records which may be grouped together and may contain short or blank values is great. The above examples demonstrate that MatchUp has to at some point make a decision as to which group a blank value really matches. By default, the order in which incoming records are processed determine whether a record will be added to an existing group or create a new dupe group. | |||
[[Category:MatchUp Hub]] | |||
[[Category:Matchcode Optimization]] |
Latest revision as of 23:38, 21 September 2018
Blank Matching
Specifics
Summary
Sometimes it is desirable to create a matchcode that will prevent matches when two compared values are present and unique, but allow the match when one of the values is blank or an initial abbreviation. Enabling Short/Empty options determine blank value behavior.
Returns
A match if the value is the same, or if its blankness or initial satisfies the configured match conditions.
Example Matchcode Usage 1
Example Data 1
FIRST LAST RESULT John Smith Match Found J Smith Match Found Smith Match Found Mary Smith Unique
Example Matchcode Usage 2
Example Data 2
LAST ADDRESS RESULT Smith 12 Main St apt 3 Match Found Smith 12 Main St Match Found Smith 12 Main St apt 2 Unique Smith 12 Main St Match Found
In both of the above examples, the unmatched record could have been found as (and indeed could be) a match to one of the other ‘one-blank’ records. But the previously processed short record had already been placed into another duplicate group.
Performance | |||||
---|---|---|---|---|---|
Slower | Faster | ||||
Matches | |||||
More Matches | Greater Accuracy |
Recommended Usage
Hybrid deduper, where a single incoming record can quickly be evaluated independently against each record in an existing large master database.
Small batch runs where the actual number of blank values is minimal.
Not Recommended For
Batch processes where the number of records which may be grouped together and may contain short or blank values is great. The above examples demonstrate that MatchUp has to at some point make a decision as to which group a blank value really matches. By default, the order in which incoming records are processed determine whether a record will be added to an existing group or create a new dupe group.