FieldTransform

image_pdfimage_print

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.

Source Month_Numbers
Treeformat fh
Functions Type
MonthText Map
QuarterText Map

Note: to set a ” ” (space value) for a function parameter, you have to enter “#space”. You can, however, use ” ” within a function parameter.

Examples:

#space -> ” “
#spaceHello World#space#space -> ” Hello World “

For descriptions of the individual function types, follow the links below:

Aggregation Concatenation DateDuration
DateFormat Groovy Java
JavaScript LastNonEmpty Lookup
LookupInterval Map  NumberFormat 
OlapData Previous Replace
RowNumber Split SubString
Switch UpperLower  
image_pdfimage_print
Was this post helpful?
NoYes (-3 rating, 5 votes)
Loading...