Field Transform 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 function, such as Replace, Lookup, Concatenation, etc. One or more fields from the source are converted into one output field. A Field Transform can have several functions, which 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 + button in the Functions section, as shown below.
The target table defines the output structure of the Field Transform. 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: