1.3.11.15 Enhance from Map

The Enhance from Map processor allows you to add a new attribute to the data by mapping matching values from an existing attribute.

Use Enhance from Map where new data can be derived from existing data. For example, records without a Gender, but with a gender-specific Title such as Mr or Mrs could have a new gender attribute added using Reference Data, with entries such as:

The following table describes the configuration options:

Configuration	Description
Inputs	Specify the single attribute to match against the lookup column in the map.
Options	Specify the following value map options: Reference data: the Reference Data with the map of the lookup value to the new attribute value. Specified as Reference Data. Default value: None. Specify the following match options: Ignore Case?: whether or not to ignore case when matching against the Reference Data. Specified as Yes/No. Default value: Yes. Match list by: drives how to match the Reference Data. Specified as a Selection (Whole Value/Starts With/Ends With/Contains). Default value: Whole value.
Outputs	Describes any data attribute or flag attribute outputs.
Data Attributes	The following data attributes are output: EnhancedResult: the new attribute containing the added (mapped) value. Value is the mapped value in the Reference Data, where there was a match, or a Null value, where there was no match to the Reference Data.
Flags	The following flags are output: EnhancedFlag: indicates which data has been enhanced. Possible values: Y/N.

The following table describes the statistics produced by the profiler:

Statistic	Description
Enhanced	The number of records that matched the reference list, and were therefore enhanced with a new attribute value.
Unenhanced	The number of records that did not match the reference list, and were therefore not enhanced.

Output Filters

The following output filters are available:

• Records that were enhanced using the Reference Data lookup

• Records that were not enhanced using the Reference Data lookup

Example

In this example, Enhance from Map is used to add an attribute renamed to TitleGender, where records have a gender-specific Title:

Title	TitleGender
Ms	F
Ms	F
Miss	F
Mr	M
Mr	M
Ms	F
Miss	F
Mr	M