Developer Transformation Guide

10.4.0
- 10.5.2
- 10.5
- 10.4.1

Back Next

Flatten Map

The transformation flattens a map into two fields for the key and value elements in the map. For a map field that you flattened, you cannot change the value of Occurs from Auto to an integer value.

For example, you want to flatten the following map field emp_sal with a string key and an array of integer values:

<emp_name -> [base_sal, bonus, commision]>

The following image shows the map field that you want to flatten in the Normalizer view:

The Normalizer view shows a string field emp_id and a map field emp_sal. The value of Occurs for the string and map fields is 1.

The table contains the following values:

emp_id	emp_sal
12200	<Greg -> [4000, 1000, 500]>
12201	<Patricia -> [3800, 1500, 1000]>

When you flatten the map port, the output returns a string field for the map key and an array field for the map value as follows:

emp_id	emp_sal_Key	emp_sal_Value	GCID_emp_salary
12200	Greg	[4000, 1000, 500]	1
12201	Patricia	[3800, 1500, 1000]	1

The following image shows the map field that is flattened to a string key field and an array value field in the Normalizer view:

The Normalizer view shows the map field emp_sal that is flattened to a string field emp_sal_Key and an array field emp_sal_Value with a type configuration string []. A flatten icon is displayed next to the flattened fields. The value of Occurs for the flattened field emp_sal is Auto.

The following image shows the Output group in the Ports view:

The Ports view of the Normalizer transformation shows an input group with a string port emp_id and a map port emp_sal. The output group contains a string port emp_id, the flattened fields of the map port emp_sal, and a bigint port GCID_emp_sal. The flattened fields of the map port are emp_sal_key of type string and emp_sal_Value of type array with a type configuration string [].

Rename Saved Search

Table of Contents

Developer Transformation Guide

Developer Transformation Guide

Flatten Map

Flatten Map