/
JSON_ELEMENTS

JSON_ELEMENTS

Owned by Juliane Wetzel
Feb 07, 2020

Syntax

JSON_ELEMENTS(<string>;N)

Description

Returns the top N elements of a JSON array.

If N is left blank, all elements of the JSON array are returned.

Examples

Column 1NJSON_ELEMENTS returns
[a,b,null]1a
[a,b,null]2a, b
[a,b,null]3a, b, null

Related content

JSON_ELEMENTS
JSON_ELEMENTS
Datameer v7
More like this
JSON_ELEMENTS
JSON_ELEMENTS
Datameer X v11
More like this
JSON_ELEMENT
JSON_ELEMENT
Datameer X v10
More like this
JSON_ELEMENT
JSON_ELEMENT
Datameer v7
More like this
JSON_ELEMENT
JSON_ELEMENT
Datameer X v11
More like this
JSON_KEYS
JSON_KEYS
Datameer v7
More like this