UNNEST

Turns any {data} into a tabular structure (2D), generating 1 row per combination of array elements.

Parameter List

Syntax
UNNEST(data)
data

The JSON array to be unnested.

More details

The function gets all nested objects and adds them to the root of the data. If there are multiple values, new objects are created. The number of results might be greater than the original data.

Examples

UNNEST(A1) returns [{"name": "Pierre", "location": "France"},{"name": "Pierre", "location": "UK"}]