unpivot_array¶
Description¶
Convert an object into an array of “key”-“value” pairs.
Return type¶
generic array
Domain¶
This is a scalar function (calculates a single output value for a single input row.)
Categories¶
Usage¶
unpivot_array(object, keyFieldName, valueFieldName)
Argument |
Type |
Optional |
Repeatable |
Restrictions |
|---|---|---|---|---|
object |
object |
no |
no |
none |
keyFieldName |
string |
no |
no |
none |
valueFieldName |
string |
no |
no |
none |
Examples¶
unpivot_array(object(FIELD.foo), "key", "value")
Converts ‘{“k1”: “v1”, “k2”: “v2”, …}’ to ‘[{“key”: “k1”, “value”: “v1”}, {“key”: “k2”, “value”: “v2”}, …]’
Aliases¶
array_unpivot (deprecated)