The FieldTransform is used to model a field-based transformation of the data source. The source data can be any extract or transform and will be processed row by row. The tree format is only necessary when the source is tree-based. It defines how the tree is converted into a table.
The field-wise transformations are defined using a so-called function e.g. Replace, Lookup or Concatenate. One or more fields from the source are converted into one output field. A FieldTransform can have several functions. Functions can be implemented one after the other within a transform, i.e. the result of a function can be the input of another function.
The Function Editor appears when you click the “Add” button.
The target table defines the output structure of the FieldTransform. Each output column requires the following settings :
|Field Name||An arbitrary name under which the column can be referenced further in the Jedox Integrator process.|
|Input||Either a reference or a constant value. There is a toggle box on the right of the input field with which you can switch between both cases. The reference is set to a column of the source or to a function|
If no target table is defined, the output structure consists of all columns of the source plus all functions.
Note: to set a ” ” (space value) for a function parameter, you have to enter “#space”. You can, however, use ” ” within a function parameter.
#space -> ” “
#spaceHello World#space#space -> ” Hello World “
For descriptions of the individual function types, follow the links below: