Match Transformation: Absolute Value
The Absolute Value transformation is a simple transformation that converts numbers to their absolute value, (that is, removing their sign (positive or negative), and stripping any unnecessary digits (such as zeroes at the beginning of the value)).
Use the Absolute Value transformation when for matching purposes you are concerned with only the absolute value of numbers, and not whether they are positive or negative, or whether they are stored in different formats (for example, with a different amount of digits stored).
Example
In this example, the Absolute Value transformation is used to match volume amounts. The amounts are expected to be positive, but there may be occasional errors in the data where a negative amount has been specified.
Example Transformations
The following table shows example Absolute Value transformations:
Table 1-72 Example Transformations
| Value | Transformed Value |
|---|---|
|
025 |
25 |
|
-25 |
25 |
|
0000500 |
500 |
|
-500 |
500 |
|
025 |
25 |