Page History

To enter a transformation on an entity, select the Properties screen for that entity, either by right-clicking on the entity in the diagram and choosing Properties:
REPLACE WITH THIS IMAGE: Images/Entities/Entering a Transformation for an Entity.png Image Added 
or by right-clicking on the entity in the repository tree and choosing Properties:
REPLACE WITH THIS IMAGE: Images/Entities/Entering a Transformation for an Entity_1.png Image Added

1. Select the Data Transformation tab.

...

1. 
   Image Added
   

   Note
   title Note
   The Data Transformation tab is only visible if data transformations are enabled in the category settings, refer to Entity/ General Settings for details.

2. Select a a Transformation or create one.

   Icons	Description

   REPLACE WITH THIS IMAGE: Images/Common_Icons/addqueryicon.png

   Image Added

   Click to Add a transformation.

   REPLACE WITH THIS IMAGE: Images/Common_Icons/renamequeryicon.png

   Image Added

   Click to Edit the selected transformation.

   REPLACE WITH THIS IMAGE: Images/Common_Icons/copyqueryicon.png

   Image Added

   Click to make a Copy of the selected transformation.

   REPLACE WITH THIS IMAGE: Images/Common_Icons/removequeryicon.png

   Image Added

   Click to Delete the selected transformation.

3. In the right pane, enter the following details for the transformation.
4. Select the buttons to the right of the Change and Condition fields to define change and conditional functions for the selected columns.

   Icons	Description

   REPLACE WITH THIS IMAGE: Images/Common_Icons/db_column.png

   Image Added

   Click Highlight attribute to highlight some text in the change/condition field, which will then be replaced by the columns selected in the Columns field.

   REPLACE WITH THIS IMAGE: Images/Common_Icons/function.png

   Image Added

   Click Insert function to select a database function to be inserted.

   REPLACE WITH THIS IMAGE: Images/Entities/Entering a Transformation for an Entity_6.png

   Image Added

   Image Added

   REPLACE WITH THIS IMAGE: Images/Common_Icons/file_table.png

   Click Clear highlight to clear the highlights (all or by user selection).

   REPLACE WITH THIS IMAGE: Images/Common_Icons/refresh.png

   Image Added

   Click Refresh highlights to refresh the text field to check the highlighting.

5. Enter Encapsulate characters to be used in the Preview section.
6. Select the Define as SELECT query checkbox to create a SELECT query in the Preview section. If the checkbox is not selected, an UPDATE query is created in the Preview section.
   

   Note
   title Note
   If multiple columns are selected in the Columns

   field

   field,

   the

   the Preview

   section

   section will contain multiple queries, separated by semicolons.

7. Click the Test button to test your transformation and to view the results.
   

REPLACE WITH THIS IMAGE: Images/Entities/Entering a Transformation for an Entity_7.png

1. Image Added
2. Click Click OK.