/
JSONTOLIST

JSONTOLIST

Owned by Juliane Wetzel
Feb 07, 2020

Syntax

JSONTOLIST(<string containing a JSON array>)

Description

Converts the selected JSON data type column into a List data type column.

Examples

Column1JSONTOLIST returns
["red","blue","yellow"][red, blue, yellow]
[red, blue, yellow][red, blue, yellow]
[red, blue, "yellow"][red, blue, yellow]
["1","44","21","4"][1, 44, 21, 4]
[1, 44, 21, 4][1, 44, 21, 4]
[1, 44, "21", 4][1, 44, 21, 4]
[{"ID1":"1"},{ID2:2},{ID3:"3"}][{"ID1":"1"}, {"ID2":2}, {"ID3":"3"}]

Related content

JSONTOLIST
JSONTOLIST
Datameer v7
More like this
JSONTOLIST
JSONTOLIST
Datameer X v11
More like this
TOJSON
TOJSON
Datameer X v11
More like this
TOJSON
TOJSON
Datameer X v10
More like this
TOJSON
TOJSON
Datameer v7
More like this
JSON_VALUE
JSON_VALUE
Datameer X v10
More like this