Pentaho:MatchUp:Options - Revision history

Admin at 22:10, 15 June 2015

2015-06-15T22:10:54Z

← Older revision		Revision as of 22:10, 15 June 2015
Line 264:		Line 264:
	Double-clicking any element in the expression elements section will insert it into the "Use the specified expression:" field.		Double-clicking any element in the expression elements section will insert it into the "Use the specified expression:" field.

	For more information, see [[Pentaho:MatchUp:~~Custom~~ Expression:Elements\|Expression Elements]].		For more information, see [[Pentaho:MatchUp:Expression Elements\|Expression Elements]].

	The following elements are available for your use:		The following elements are available for your use:
	*[[Pentaho:MatchUp:~~Custom~~ Expression:Elements#Columns\|Columns]]		*[[Pentaho:MatchUp:Expression Elements#Columns\|Columns]]
	*[[Pentaho:MatchUp:~~Custom~~ Expression:Elements#Variables\|Variables]]		*[[Pentaho:MatchUp:Expression Elements#Variables\|Variables]]
	*[[Pentaho:MatchUp:~~Custom~~ Expression:Elements#String Functions/Operators\|String Functions/Operators]]		*[[Pentaho:MatchUp:Expression Elements#String Functions/Operators\|String Functions/Operators]]
	*[[Pentaho:MatchUp:~~Custom~~ Expression:Elements#Numeric Functions/Operators\|Numeric Functions/Operators]]		*[[Pentaho:MatchUp:Expression Elements#Numeric Functions/Operators\|Numeric Functions/Operators]]
	*[[Pentaho:MatchUp:~~Custom~~ Expression:Elements#Boolean Functions/Operators\|Boolean Functions/Operators]]		*[[Pentaho:MatchUp:Expression Elements#Boolean Functions/Operators\|Boolean Functions/Operators]]
	*[[Pentaho:MatchUp:~~Custom~~ Expression:Elements#Date/Time Functions/Operators\|Date/Time Functions/Operators]]		*[[Pentaho:MatchUp:Expression Elements#Date/Time Functions/Operators\|Date/Time Functions/Operators]]
	*[[Pentaho:MatchUp:~~Custom~~ Expression:Elements#Misc. Functions/Operators\|Misc. Functions/Operators]]		*[[Pentaho:MatchUp:Expression Elements#Misc. Functions/Operators\|Misc. Functions/Operators]]
	*[[Pentaho:MatchUp:~~Custom~~ Expression:Elements#DataType Casts\|DataType Casts]]		*[[Pentaho:MatchUp:Expression Elements#DataType Casts\|DataType Casts]]


	[[Category:Pentaho]]		[[Category:Pentaho]]

Admin at 18:59, 15 June 2015

2015-06-15T18:59:50Z

← Older revision		Revision as of 18:59, 15 June 2015
Line 220:		Line 220:
	*Check the box next to the rule(s) that you wish to use.		*Check the box next to the rule(s) that you wish to use.
	*Rules are also ordered from 1-6 in order of priority. Select the rule and click either the up arrow or down arrow to change this order.		*Rules are also ordered from 1-6 in order of priority. Select the rule and click either the up arrow or down arrow to change this order.

			;Data Quality Score
			:The Data Quality Score evaluates all possible results combined from Address, Email, Name, Phone and GeoCode in a single column.

	;Address Quality Score		;Address Quality Score
Line 235:		Line 238:
	;GeoCode Quality Score		;GeoCode Quality Score
	:The GeoCode Quality Score evaluates your GeoCode Results and selects which one has the highest level of GeoCoding accuracy.		:The GeoCode Quality Score evaluates your GeoCode Results and selects which one has the highest level of GeoCoding accuracy.

	~~;Data Quality Score~~
	~~:The Data Quality Score evaluates all possible results combined from Address, Email, Name, Phone and GeoCode in a single column.~~

Admin at 18:58, 15 June 2015

2015-06-15T18:58:09Z

Show changes

Admin: Created page with "{{PentahoMatchUpNav |MatchUpCollapse= }} {{CustomTOC}} The Options tab allows you to specify which of the available output results you want returned. [[File:PENT_MatchUp_O..."

2015-06-13T00:57:17Z

Created page with "{{PentahoMatchUpNav |MatchUpCollapse= }} {{CustomTOC}} The Options tab allows you to specify which of the available output results you want returned. [[File:PENT_MatchUp_O..."

New page

{{PentahoMatchUpNav
|MatchUpCollapse=
}}

{{CustomTOC}}

The Options tab allows you to specify which of the available output results you want returned.

[[File:PENT_MatchUp_Options.png|link=]]

==Output Columns==
In addition to the source data, you will often want to output processing information about the disposition of a record. This allows you to analyze the results in a number of ways.

;Result Codes
:This field displays the results of the comparison, whether the record is unique or is a duplicate, was suppressed or intersected, which matchcode combination resulted in a match, etc. See MatchUp Result Codes for a list of possible Result Codes that the component can return.

;Dupe Group
:Each group of matching records is assigned a sequential unique group number. This field displays the group number that the record, whether unique or a member of a duplicate grouping, is in.

;Dupe Count
:This field displays the number of matching records in each Dupe Group.

;Matchcode Key
:Based on the matchcode and matchcodes component used to process the source table(s), every record has a matchkey built. It is this key, a representation of the record, that is used in deduping. This field will be populated with the key and is useful in analyzing the output results.

==Lookup Options==
<span style="color:red;">'''*This section is GREYED-OUT When there is only a single upstream source connected to the MatchUp Component.'''</span>

When a second upstream data source is connected to the Lookup pin, that data source will be used as a filter.

;List Suppress
:Source pin records that match any record from the Lookup Pin will not be returned with an Output Result Code. They will be marked as Suppressed.

;List Intersect
:Only Source pin records that match any record from the Lookup Pin will be returned with an Output Result Code (Unique or Has Duplicate result code). The second to nth Source records that match the Lookup record will be marked with a Duplicate Result Code. Source pin records that do not match any Lookup pin records will be returned with a Non-Intersected Result Code.

;No Purge
:Source pin records that match other Source pin records will not be matched. In other words, a suppressed group or an intersected group will be returned as suppressed or intersected, but each record will have their own Dupe Group number.

==Golden Record==
The Golden Record Selection Options allow for intelligent selection of the Golden or Master Record using different logic and algorithms. These algorithms include selecting the Golden Record according to: Latest Date, Most Complete, Data Quality Score, and Custom Built Expressions.

[[Category:Pentaho]]

← Older revision		Revision as of 22:10, 15 June 2015
Line 264:		Line 264:
	Double-clicking any element in the expression elements section will insert it into the "Use the specified expression:" field.		Double-clicking any element in the expression elements section will insert it into the "Use the specified expression:" field.

	For more information, see [[Pentaho:MatchUp:~~Custom~~ Expression:Elements\|Expression Elements]].		For more information, see [[Pentaho:MatchUp:Expression Elements\|Expression Elements]].

	The following elements are available for your use:		The following elements are available for your use:
	*[[Pentaho:MatchUp:~~Custom~~ Expression:Elements#Columns\|Columns]]		*[[Pentaho:MatchUp:Expression Elements#Columns\|Columns]]
	*[[Pentaho:MatchUp:~~Custom~~ Expression:Elements#Variables\|Variables]]		*[[Pentaho:MatchUp:Expression Elements#Variables\|Variables]]
	*[[Pentaho:MatchUp:~~Custom~~ Expression:Elements#String Functions/Operators\|String Functions/Operators]]		*[[Pentaho:MatchUp:Expression Elements#String Functions/Operators\|String Functions/Operators]]
	*[[Pentaho:MatchUp:~~Custom~~ Expression:Elements#Numeric Functions/Operators\|Numeric Functions/Operators]]		*[[Pentaho:MatchUp:Expression Elements#Numeric Functions/Operators\|Numeric Functions/Operators]]
	*[[Pentaho:MatchUp:~~Custom~~ Expression:Elements#Boolean Functions/Operators\|Boolean Functions/Operators]]		*[[Pentaho:MatchUp:Expression Elements#Boolean Functions/Operators\|Boolean Functions/Operators]]
	*[[Pentaho:MatchUp:~~Custom~~ Expression:Elements#Date/Time Functions/Operators\|Date/Time Functions/Operators]]		*[[Pentaho:MatchUp:Expression Elements#Date/Time Functions/Operators\|Date/Time Functions/Operators]]
	*[[Pentaho:MatchUp:~~Custom~~ Expression:Elements#Misc. Functions/Operators\|Misc. Functions/Operators]]		*[[Pentaho:MatchUp:Expression Elements#Misc. Functions/Operators\|Misc. Functions/Operators]]
	*[[Pentaho:MatchUp:~~Custom~~ Expression:Elements#DataType Casts\|DataType Casts]]		*[[Pentaho:MatchUp:Expression Elements#DataType Casts\|DataType Casts]]


	[[Category:Pentaho]]		[[Category:Pentaho]]