Tree Element Transform


This transform is used to transform elements, attributes, and consolidations of a tree-based data source.

It is comparable to the FieldTransform for table-based data sources. The element-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. Functions can be implemented one after the other within a transform, i.e. the result of one function can be the input of another function.

The source data can be any tree-based extract or transform and will be processed element by element using the PCWAT-format.
So, these input fields should be provided:

Optional: one field for each attribute with its attribute name.

The attribute table defines the attributes of the resulting tree. Each attribute requires the following settings :
– Attribute Name : An arbitrary name
– Input : < wie in FieldTransform>
If no attribute table is defined, all attributes of the tree-based source plus all functions (except those starting with “:” ) are attributes of the resulting tree.

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  
Advanced setting

Subtree for function evaluation:
This defines the part of the tree-source for which the functions are evaluated with filter conditions like in transform TreeView. If not set, the functions are evaluated for the whole tree-source.

For the script functions Groovy and JavaScript there is a specific API method for tree element handling available. It delivers information on the hierarchical structure, for example a list of children and parents of an element. More details see the article Integrator Scripting API

For further usecases you can import the Jedox Integrator project sampleTreeElement from <Jedox_install_path\tomcat\webapps\etlserver\data\samples>.