To set up a transformation list action rule, a transformation list is required. If the desired value transformation does not exist, set up a new transformation list or add the transformation to an existing transformation list.
For each transformation list, set up the value transformations. For each value transformation, define the source value and the target value.
Example:
You can set up a transformation list to transform country codes into the relevant currencies for these countries. In this case, the source field is a country field, and the target field is a currency field. If the country is US, and the transformation list action rule is applied, the currency is set to USD.
Standard procedure
| 1. |
Click Data quality management. |
| 2. |
Click Transformation lists. |
| 3. |
Click New. |
| 4. |
In the Transformation ID field, type a value. |
| 5. |
In the Description field, type a value. |
| 6. |
Click New. |
| 7. |
Define the value to be transformed. |
| |
In the Source value field, type a value. |
| 8. |
Define the value into which the source value must be transformed. |
| |
In the Target value field, type a value. |
| 9. |
Close the page. |