Aggregate FunctionsMake / Collect

make_list_with_nulls

Returns a dynamic (JSON) array of all values of `expr` in the group, including nulls.

Like make_list, the result is truncated to 1,048,576 values.

Syntax

make_list_with_nulls(expr)

Prop

Type

Returns: dynamic

datatable(shape:string, sides:int)[
  "triangle", int(null),
  "square", 4,
  "pentagon", 5
]
| summarize sides = make_list_with_nulls(sides)

sides (dynamic)
[null,4,5]

make_list_if

Returns a dynamic (JSON) array of values of `expr` for the rows in the group where `predicate` is true.

make_set

Returns a dynamic (JSON) array of all distinct values of Expr in the group.