FlattenArrays
Specifies the number of elements you want to return from nested arrays, as columns of their own. Only recommended for arrays that are expected to be short.
Data Type
string
Default Value
""
Remarks
By default, nested arrays are returned as XML/JSON strings. Set FlattenArrays to the number of elements you want to return from nested arrays. The specified elements are returned as columns, with the zero-based index concatenated to the column name. Other elements are ignored.
For example, to return an arbitrary number of elements from an array of strings:
["FLOW-MATIC","LISP","COBOL"]When FlattenArrays is set to 1, the preceding array is flattened into the following table:
| Column Name | Column Value |
| languages.0 | FLOW-MATIC |
To flatten all the elements of nested arrays, set FlattenArrays to -1.