REMOVEARRAYS

Removes all nested arrays from a data structure. Use the exceptions to keep some of the arrays.

Parameter List

Syntax
REMOVEARRAYS(data
[exceptions]
)
data

The data structure with nested arrays.

[optional] exceptions

The arrays you want to keep in data. For example: ["contacts","location"].

More details

The function removes all nested arrays from a data structure. Define exceptions to keep just the arrays you need to build your tables.

Examples

REMOVEARRAYS(A1) returns {"name": "John"}