User Guide

10.2.2
- 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.1

Back Next

Flatten Hierarchical Data

You can flatten elements of hierarchical data into relational data. Use the

Flatten Complex Port

wizard in the Developer tool to perform the conversion.

The wizard converts hierarchical data to relational data. When you have hierarchical data with nested data type, you can select specific elements or all elements of complex data type to flatten.

Based on the data type of the complex port, the wizard performs the following tasks:

struct: Adds an Expression transformation with flattened output ports. The expression for the output ports uses the dot operator to extract elements in the struct.
Adds a final Expression transformation that contains a dynamic port with all ports from the upstream transformation including the flattened struct ports.
array: Adds a Normalizer transformation with flattened output ports. The wizard flattens the array field in the Normalizer view.; Adds a final Expression transformation that contains a dynamic port with all ports from the upstream transformation including the flattened array ports.
nested data type: Adds one or more Expression and Normalizer transformations with flattened output ports. If you select a child element of a nested complex port, the wizard flattens both the parent and child elements.; Adds a final Expression transformation that contains a dynamic port with all ports from the upstream transformation including the flattened ports.

Rename Saved Search

Table of Contents

User Guide

User Guide

Flatten Hierarchical Data

Flatten Hierarchical Data