unpivot_array(object: object, keyFieldName: string, valueFieldName: string) -> array of object

Convert an object into an array of "key"-"value" pairs.

Domain

This is a scalar function (calculates a single output value for a single input row).

Categories

• Semistructured
• String

Examples

unpivot_array(object(FIELD.foo), "key", "value")

Converts {"k1": "v1", "k2": "v2", ...} to [{"key": "k1", "value": "v1"}, {"key": "k2", "value": "v2"}, ...].