Matchcode Optimization:Blank Matching - Revision history

Admin at 23:38, 21 September 2018

2018-09-21T23:38:35Z

← Older revision		Revision as of 23:38, 21 September 2018
Line 4:		Line 4:

	==Blank Matching==		==Blank Matching==
	;Specifics		===Specifics===
	[[MatchUp Object:Blank Field Matching\|Blank Field Matching]]		*[[MatchUp Object:Blank Field Matching\|Blank Field Matching]]

	;Summary		===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.		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		===Returns===
	A match if the value is the same, or if its blankness or initial satisfies the configured match conditions.		A match if the value is the same, or if its blankness or initial satisfies the configured match conditions.

2018-09-21T22:04:10Z

← Older revision		Revision as of 22:04, 21 September 2018
Line 1:		Line 1:
	~~{{UnderConstruction}}~~
	{{MatchcodeOptimizationNav		{{MatchcodeOptimizationNav
	\|MatchcodeOptimizationCollapse=		\|MatchcodeOptimizationCollapse=
Line 14:		Line 13:
	A match if the value is the same, or if its blankness or initial satisfies the configured match conditions.		A match if the value is the same, or if its blankness or initial satisfies the configured match conditions.

	===Example Matchcode Usage===		===Example Matchcode Usage 1===
	[[File:MCO_Algorithm_BlankMatching_ShortApt.png\|link=]]		:[[File:MCO_Algorithm_BlankMatching_ShortApt.png\|link=]]

	===Example Data===		===Example Data 1===
	{{ExampleDataTableV1\|FIRST\|LAST\|RESULT		{{ExampleDataTableV1\|FIRST\|LAST\|RESULT
	\|AdditionalRows=		\|AdditionalRows=
Line 26:		Line 25:
	}}		}}

	===Example Matchcode Usage===		===Example Matchcode Usage 2===
	[[File:MCO_Algorithm_BlankMatching_ShortName.png\|link=]]		:[[File:MCO_Algorithm_BlankMatching_ShortName.png\|link=]]

	===Example Data===		===Example Data 2===
	{{ExampleDataTableV1\|LAST\|ADDRESS\|RESULT		{{ExampleDataTableV1\|LAST\|ADDRESS\|RESULT
	\|AdditionalRows=		\|AdditionalRows=

2018-09-21T21:43:36Z

← Older revision		Revision as of 21:43, 21 September 2018
Line 25:		Line 25:
	{{EDTRow\|Red\|Mary\|Smith\|Unique}}		{{EDTRow\|Red\|Mary\|Smith\|Unique}}
	}}		}}


	===Example Matchcode Usage===		===Example Matchcode Usage===
Line 31:		Line 30:

	===Example Data===		===Example Data===
	:{\| ~~class="alternate01"~~		{{ExampleDataTableV1\|LAST\|ADDRESS\|RESULT
	!LAST!!ADDRESS!!RESULT		\|AdditionalRows=
	\|-		{{EDTRow\|Green\|Smith\|12 Main St apt 3\|Match Found}}
	\|~~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}}
	~~\|SMITH~~\|\|12 ~~MAIN ST~~\|~~\|MATCH FOUND~~		{{EDTRow\|Green\|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.		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.

2018-09-21T18:12:05Z

← Older revision		Revision as of 18:12, 21 September 2018
Line 44:		Line 44:

	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.		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		{{MatchcodePerformance
Line 49:		Line 50:
	\|Matches3=		\|Matches3=
	}}		}}


	===Recommended Usage===		===Recommended Usage===

2018-09-21T18:11:45Z

2018-09-21T18:02:09Z

2018-09-21T17:52:04Z

2018-09-21T16:02:34Z

← Older revision		Revision as of 16:02, 21 September 2018
Line 18:		Line 18:

	===Example Data===		===Example Data===
	{{ExampleDataTableV1\|~~First~~\|~~Last~~\|~~Result~~		{{ExampleDataTableV1\|FIRST\|LAST\|RESULT
	\|AdditionalRows=		\|AdditionalRows=
	{{EDTRow\|Green\|John\|Smith\|Match Found}}		{{EDTRow\|Green\|John\|Smith\|Match Found}}

2018-09-21T15:53:56Z

← Older revision		Revision as of 15:53, 21 September 2018
Line 18:		Line 18:

	===Example Data===		===Example Data===
	:{\| ~~class="alternate01"~~		{{ExampleDataTableV1\|First\|Last\|Result
	~~!FIRST!!LAST!!RESULT~~		\|AdditionalRows=
	\|-		{{EDTRow\|Green\|John\|Smith\|Match Found}}
	\|~~JOHN~~\|\|~~SMITH~~\|~~\|MATCH FOUND~~		{{EDTRow\|Green\|J\|Smith\|Match Found}}
	\|-		{{EDTRow\|Green\| \|Smith\|Match Found}}
	\|J\|\|~~SMITH\|\|MATCH FOUND~~		{{EDTRow\|Red\|Mary\|Smith\|Unique}}
	\|-		}}
	\| \|\|~~SMITH\|\|MATCH FOUND~~
	\|-
	\|~~MARY~~\|\|~~SMITH\|\|UNIQUE~~
	\|}

	===Example Matchcode Usage===		===Example Matchcode Usage===

2018-09-20T18:04:58Z

← Older revision		Revision as of 18:04, 20 September 2018
Line 15:		Line 15:

	===Example Matchcode Usage===		===Example Matchcode Usage===
	[[File:MCO_Algorithm_BlankMatching_ShortApt.png\|link=]]		[[File:MCO_Algorithm_BlankMatching_ShortApt.png\|link=]]

	===Example Data===		===Example Data===