You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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:

  • sourceSet: The source set object of the matched entity.
    The default value "- sourceSet.name.matches(".") -{*}" can be used to generate queries for all available source sets.

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:

  • table: The table object for the entity of the matched attribute.
  • transformationColumn: The column object for the matched attribute.

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:

  • table: The table object for the entity of the matched attribute.
  • transformationColumn: The column object for the matched attribute.
  • No labels