make_object¶

Description¶

Turn a sequence of name:value elements into an object. Without arguments, returns an empty, non-null object literal.

object

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

make_object( [ options ] [ , key_value ] ... )

Argument	Type	Required	Multiple	Constant
options	options	Optional	Only one	Variable
key_value	variant	Optional	Can be multiple	Variable

Option	Type	Meaning
keep_nulls	bool	Determines whether key-value pairs with null values are kept in the object (`true`) or discarded (`false`). Default is `false` (discard).

make_col obj:make_object(label:"speed", value:distance/(endtime-starttime), attime:endtime)

Make a new column ‘obj’ consisting of an object with keys ‘label’, ‘value’, and ‘attime’.

make_col obj:make_object()

Make a new column ‘obj’ consisting of an empty object that is not ‘null’.

make_col obj:make_object(options(keep_nulls:true), 'apple':string_null())

Make a new column ‘obj’ consisting of an object {"apple": null}.

makeobject (deprecated)