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