Output Selector: Highest Value

1.3.3.10.5 Output Selector: Highest Value

The Highest Value output selector selects the 'Highest Value' for an attribute from all the records being merged. This is most useful for Number or Date attributes, to select the highest number or latest date for an attribute. For String attributes, it will select the last value using an alphabetic sort on the data.

Use the Highest Value selector for output attributes that are selecting Number or Date values, and where the best value is likely to be the highest, or latest.

For example, when de-duplicating data, the best value for a Number attribute such as Largest_Purchase, registering the amount of the largest single order the customer has made, will be the highest of the values in the matching records, and the best value for a Date attribute such as Last_payment is likely to be the latest of the Date values.

The following table describes the configuration options:

Configuration Description

Configuration	Description
Inputs	Any Number or Date attributes from any input data sets.
Options	Specify the following options: `Use first non-empty value if tied?`: this option provides a way of selecting a value arbitrarily if all records in the group have the same value in the check attribute. The first alphabetically sorted value will be selected for String values, the lowest value for Numbers, and the earliest value for Dates. Type: Yes/No. Default value: Yes.

Inputs

Any Number or Date attributes from any input data sets.

Options

Specify the following options:

Use first non-empty value if tied?: this option provides a way of selecting a value arbitrarily if all records in the group have the same value in the check attribute.

The first alphabetically sorted value will be selected for String values, the lowest value for Numbers, and the earliest value for Dates.

Type: Yes/No. Default value: Yes.

Example

In this example, the Highest Value output selector is used to select the Highest Value for a Largest_purchase (Number) attribute from the values for this attribute for each record in a match group.

Example configuration

Use first non-empty value if tied? = No

Example output

The following table shows examples of output selection using the above configuration:

Table 1-104 Example Output Using Highest Value Selector

Record A	Record B	Output value (Highest Value)
456.44	1088.20	1088.20
48765	2711	48765
34	33	34
2860	2860	Selection error (needs manual resolution)