Skip to main content

Defining transformations for a single table/view

ON THIS PAGE

Defining transformations for a single table/view

Note:

Although the descriptions in this section only refer to tables, the procedures describe herein are applicable to views as well. When a transformation is defined for a view, the word "View(s)" will appear in the UI instead of the word "Table(s)".

This section describes how to define data transformations. Data transformations are performed when the task is run. They are optional. If you do not define any transformations, the data is replicated "as is" from the source to the target.

Qlik Replicate lets you make the following changes to the tables and columns:

  • Rename any column for the target table
  • Delete a target column
  • Change the data type and/or the length of any target column
  • Add additional target columns
  • Designate which target columns (i.e. segments) will comprise the Unique Index
  • Recalculate the data

Limitations

Transformations are subject to the following limitations:

  • They are not supported for calculating columns of Right-to-Left languages.
  • Transformations cannot be performed on columns that contain special characters (e.g. #, \, /, -) in their name.
  • They cannot be performed on columns that have a pound character (#) in their name.
  • The only supported transformation for LOB/CLOB data types is to drop the column on the target.

You can use the method described here for transformations that are specific to a single table or a few tables in your task. To make a similar change over multiple tables, see Defining Global transformations.

For an explanation of how to configure transformations, see Using the Transform tab.

  1. Select the table you want to transform and open the Table Settings window.
  2. Click Transform on the left side of the window.

The following figure shows the information in the Transform tab of the Table Settings window.

Transform tab of Table Settings dialogue example