Adds a data transformation for each matched attribute to each matched entity.

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.

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%)

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

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.