The Normalizer transformation flattens a one-dimensional array to a primitive data type and an n-dimensional array to an (n-1)-dimensional array. The number of rows that the transformation creates is the same as the size of the array.
For example, if you flatten an array port with 10 string elements, the output returns 10 string ports. If you flatten a 3-dimensional array, the output returns a 2-dimensional array.
A table contains a string port Name and an array port Phones. You want to flatten the array port. The table contains the following values:
Name
Phones
Adams
[205-128-6478, 722-515-2889, 650-213-4020]
Jane
[650-321-4506]
When you flatten the array port, the output is as follows:
Name
Phones
GCID_Phones
Adams
205-128-6478
1
Adams
722-515-2889
2
Adams
650-213-4020
3
Jane
650-321-4506
1
You can edit the Occurs value of a flattened field to extract a specific number of elements in the array. The value must be a positive integer greater than 1. The value determines the number of elements to extract. For example, you can change the value of Occurs to 2 to extract the first two elements of the array. The output is as follows: