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:
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 further usecases you can import the Jedox Integrator project sampleTreeElement from <Jedox_install_path\tomcat\webapps\etlserver\data\samples>.