Adds a data transformation for each matched attribute to each matched entity.
REPLACE WITH THIS IMAGE: Images/Model Conversions/Add Data Transformation2.png
Label |
Description |
---|---|
Match for Attribute |
Select the criteria for finding the matching attribute from the drop-down list. Refer to Model Conversion Matching Criteria for details. |
Match source set |
Select the matching source set name using a template. The following variable is available:
|
Data transformation name |
The name of the data transformation. |
Note |
|
Can use the variables %schema%, %table%, %table_label% and %column%. |
|
Description |
The description of the data transformation. |
Use template |
Indicates if the change and condition fields should be interpreted by the template engine. |
Change |
The transformation for the data transformation. (e.g. UPPER(%column%) ) |
Note |
|
The following variables are available when Use template is selected:
|
|
Condition |
Similar to the change field, but for the condition of the data transformation. (e.g. %column% IS NOT NULL) |
Note |
|
The following variables are available when Use template is selected:
|
|