Big Data Management User Guide

10.2.1
- 10.5.7
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0
- 10.2.2 HotFix 1
- 10.2.2 Service Pack 1
- 10.2.2

Back Next

Extracting Elements from a Complex Port

Use the

Extract from Complex Port

wizard to extract elements from hierarchical data.

In the transformation, select a complex port from which you want to extract elements.

Right-click the selected ports, and select

Hierarchical Conversions

Extract from Complex Port

The

Extract from Complex Port

wizard appears with the list of elements in the complex port.

In the

Select Elements

column, select the check box for each element that you want to extract.

To extract an array element, specify an array index in the

Array Index

column.

If you delete the array index, the wizard extracts the entire array. To extract an element in the struct from a complex port for an array of structs, you must specify an array index value.

The wizard shows the array index value as 0 when you select an array element.

Click

Finish

You can see the following changes in the mapping:

The mapping contains a new Expression transformation

Extract_<complex_port_name>

with the following ports:

The complex port from which you want to extract elements as the input port.

One or more output ports for the extracted elements. The number of elements that you selected to extract determines the number of output ports in the transformation.

A dynamic port with ports from the upstream transformation.