For an enrichment rule, use an enrichment line to set a field value. To set a field value, you can use several value types. Use the value type Transformation list to find a value using a transformation list and set the found value in the target field of the enrichment rule.

Before you can set up a transformation list enrichment line, set up the transformation list to be used.

You can add enrichment lines in these ways:

  • Manually.
  • Select the target fields from a page.

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 enrichment rule is applied, the currency is set to USD.

Note: You can set up a transformation list enrichment line only if the enrichment rule event is 'Source field modified'.


Standard procedure

1. Click Data quality management.
2. On the Data quality policies tab, in the list, click the link of the desired data quality policy.
3. Click the Enrichment rules tab.
4. In the enrichment rules list (left pane), find and select the desired enrichment rule.
5. Sub-task: Manually create enrichment line.
  5.1 You can manually create an enrichment line and define its target table and its target field.
  In the Enrichment lines section, click Add.
  5.2 Define the table to be used as target datasource.
Target datasources can exist, other than the source datasource. If so, you can select the source datasource or one of the other target datasources.
  In the Target data source field, enter or select a value.
  5.3 Define the target datasource field which value must be set.
  In the Target field field, enter or select a value.
 

Note: If the enrichment line is marked as 'key-field' or 'has-relation', the target field is used to define to which target datasource records the enrichment rule applies. In tis case, the target field value is not set.

6. Sub-task: Create enrichment lines by selecting fields.
  6.1 You can create enrichment lines by selecting fields from a page.
  In the Enrichment lines section, click Select fields.
  6.2 Open the page from which you want to select fields.
  6.3 On the Field picker dialog, click Select fields.
  6.4 Click the '+' button for each field that you want to select.
  6.5 On the Field picker dialog, click Done.
  6.6 On the Field picker dialog, click Submit to save the selected fields to the validation rule.
7. In the Value type field, select 'Transformation list'.
8. You can use manually defined field relations to identify records in the target datasource. The manually defined field relations setup defines to which target datasource records the enrichment rule applies.
You can use manually defined field relations, for example, if no key fields are defined, or if you want to define other field relations than defined by the key fields.
  Select the Has relation check box.
9. In the Details section, in the Transformation ID field, enter or select a value.
10. You can use a source field which value contains a lot of information. If you only need a part of the information, indicate which part of the source field value must be used. This indicated part is used as source value to find the applicable target value in the transformation list.
Example:
An IBAN number contains information like the first two characters are the country code or the fifth to eight characters are the bank identification. You can, for example, only use the country code from the IBAN as source value. To do so, select 'First (x) characters' and as filter criteria enter 2.
  In the Filter type field, select an option.
11. Define the filter criteria in line with the selected filter type.
  In the Filter criteria field, type a value.
12. Close the page.

See also

Provide feedback