pivot_array(array: array, keyFieldName: string, valueFieldName: string) -> object

Converts an array of "key"-"value" pairs into an object with key-value attributes.

Domain

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

Categories

• Semistructured
• String

Examples

pivot_array(array(FIELD.foo), "key", "value")

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