JSONTOLIST
Syntax
JSONTOLIST(<string containing a JSON array>)
Description
Converts the selected JSON data type column into a List data type column.
Examples
Column1 | JSONTOLIST 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"}] |