documentationunpivot_array¶
Description¶
Convert an object into an array of “key”-“value” pairs. Note: int64 numbers will be converted to float64 and may lose precision.
Return type¶
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 |
Required |
Multiple |
|---|---|---|---|
object |
object |
Required |
Only one |
keyFieldName |
string |
Required |
Only one |
valueFieldName |
string |
Required |
Only one |
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)