1.3.3.9.18 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 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.
The following table describes the configuration options:
| Configuration | Description |
|---|---|
|
Options |
Specify the following options:
|
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 shows examples of transformations using the above configuration:
Table 1-92 Example Transformations for Round
| Value | Transformed value |
|---|---|
|
48066.92 |
48066.9 |
|
48913.961 |
48914 |
|
48912.014 |
48912 |
|
39786.776 |
39786.8 |
|
47654.016 |
47654 |