Developer Transformation Guide

10.2.2 Service Pack 1
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5
- 10.4.1
- 10.4.0
- 10.2.2 HotFix 1
- 10.2.2
- 10.2.1

Back Next

Flatten Struct

The transformation flattens a struct into a field of the data type of the elements in the struct. To flatten a struct data type, all the struct elements must be of the same data type. The transformation creates a row for each element in the struct data type.

For example, you want to flatten the following struct field:

customer_address{
 city : string
 state : string
 zip : string
 }

The table contains the following values:

Name	customer_address
Clara	{ New York NY 10032 }

When you flatten the struct port, the output is as follows:

Name	customer_address	GCID_customer_address
Clara	New York	1
Clara	NY	2
Clara	10032	3

When the struct elements are of different data types and at least the first two elements are of the same data type, you can flatten the struct data for consecutive elements of the same data type. To extract consecutive struct elements of the same data type, edit the Occurs value. The value must be a positive integer greater than 1. For example, a struct emp_address contains the following elements:

emp_address{
 city : string
 state : string
 zip : int
 country : string
 }

You can define the value of Occurs to 2 to extract city and state struct elements. If you define the value as 3 or 4, the mapping validation fails.

Rename Saved Search

Table of Contents

Developer Transformation Guide

Developer Transformation Guide

Flatten Struct

Flatten Struct