Reference Column Type Transformer

Options

Reference "Table Name" column: Column in reference table containing the list of table names with which to filter the transformations. The available transformations will be restricted to those where the selected table name is specified
Reference "Column Name" column: The column in the reference table that contains the names of columns to be transformed
Reference "Column Type" column: The column in the reference table that contains the list of data types that each column should be transformed to
Action if data not compatible: What action to take if the data to be transformed is not compatible with the required data type
Table Name: Specify a table name which allows the input transformation control table to be filtered based on this name. If there are no table-specific transformations, then leave this as * (wildcard). This allows a single transformation control table to be used in, for example, a loop where different files are being read and may have differing column transformation requirements.

: The data table containing one or more columns to be transformed
: A table of transformations to be performed. This table consists of Table Name | Column Name | Required Data Type

: The original data table but with transformed columns
: A documentary table that simply lists the available set of transformations that the component can handle.