ArrayCompact

📘
This function isn't compatible with all data platform connections. To check if your connection supports it, see Supported data platforms and feature compatibility.

The ArrayCompact function removes null values from an array and returns the resulting array.

Syntax

ArrayCompact(array)

Function arguments


Array	The input array to remove null values from.

Usage notes

The input array should be constructed with an Array function.
If the input argument is null, the function returns null.

Examples

ArrayCompact(Array("East", "New York", Null))

Removes Null from the array and returns the array ["East", "New York"].

ArrayCompact(Array(Null, Null, Null))

Removes all nulls from the array and returns an empty array, [].

ArrayCompact(Null)

Because the input argument is null, returns Null.