You are here: Processor Library > Matching > Matching Transformations > Round

Match Transformation: Round

The Round transformation allows numbers to be rounded, for the purpose of either clustering or matching records. Numbers that are close enough to be considered the same can be rounded to a common value.

This works in exactly the same way as the main Round processor, but is specifically useful within matching when clustering or comparing numbers.

Use

Use the Round transformation if you have numerical data with varying degrees of accuracy, and you want to cluster or match using an approximation of each numeric value.

Options

Option	Type	Purpose	Default Value
Decimal places	Integer	Allows decimals to be rounded to a maximum number of decimal places	2
Round to nearest	Integer	Allows integers to be rounded to the nearest aggregation of a given integer, such as the nearest 10, or the nearest 100.	None
Round type	Selection (Up / Down / Nearest)	Drives how rounding is performed; that is, whether to round up, down or to the nearest whole value.	Nearest

Note:If the Round to nearest value is set, this over-rides the value of the Decimal places option, and rounds values to the nearest aggregation of the given integer, such as the nearest 10 (that is, effectively sets Decimal places to 0).

Example

In this example, the Round transformation is used to round an X co-ordinate of some geographical data to one decimal place.

Example configuration

Decimal places: 1

Round to nearest: (not used)

Round type: Nearest

Example transformations

The following table illustrates some examples of transformations using the above configuration:

Value	Transformed value
48066.92	48066.9
48913.961	48914
48912.014	48912
39786.776	39786.8
47654.016	47654