Versions Compared

Old Version 1

changes.mady.by.user eric revollo

Saved on

compared with

New Version Current

changes.mady.by.user eric revollo

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Adds a data transformation for each matched attribute to each matched entity.
REPLACE WITH THIS IMAGE: Images/Model Conversions/Add Data Transformation2.png Image Added

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
titleNote

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
titleNote

The following variables are available

when

when Use template

is

 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
titleNote

The following variables are available

when

when Use template

is

 is selected:

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