This property flattens nested array elements into individual columns. By default, nested arrays are returned as JSON strings. Set this property to the number of elements to extract from nested arrays.

Data Type

string

Default Value

""

Remarks

Use this property to extract elements from nested arrays and represent them as individual columns. This property is useful for simplifying the representation of short arrays in tabular output. The extracted elements are assigned column names with their zero-based index appended. Any remaining elements in the array are ignored. For example, the following array is flattened into two columns when FlattenArrays is set to 2:

 ["FLOW-MATIC", "LISP", "COBOL"]

Flattening longer arrays may result in unused elements being discarded, so it is recommended for arrays expected to contain a small number of items.