Convert data type
The data type that you define in this step is applied to all columns and tables that fit the definition you created in the Transformation scope step. Make sure that the data type you select is compatible with the data in the columns you defined.
-
Set target data type to - If you change the target value type (e.g. string to numeric), you may also need to change the data type of the target columns as well.
For the BYTES, STRING, and WSTRING data types, you can optionally specify the Length as well. If you leave the default value ("0"), Replicate will calculate the data type length based on the source column definition. You can also set the length using an expression. When you click the fx button to the right of the Length field, the Expression Builder opens showing the Metadata tab. For an explanation of the variables in this tab, see Metadata (Global transformations only).
Example:
The following expression multiplies the modified data type length by two.
$AR_M_MODIFIED_DATATYPE_LENGTH * 2
For the NUMERIC data type, you can optionally set the Precision and Scale. If you leave the default value ("0"), Replicate will calculate the precision and/or scale based on the source column value.
-
Subtype: When CLOB, NCLOB, STRING, or WSTRING data types are selected, you can also set a data subtype. Select either JSON or XML from the Subtype drop-down list. Make sure that the new data in the column will be compatible with the selected subtype. The default is Regular, which means that the regular data type will be used without a subtype.
For a description of available data types, see Replicate data types. For information about data type mapping from the native endpoint to Qlik Replicate data types, see the section for the endpoint you use. For a list of supported databases, see Supported Platforms and Endpoints.