COMPRESS

Owned by Juliane Wetzel
Last updated: May 10, 2023

Syntax

COMPRESS(<list>)

Description

Removes all null values from a list.

Examples

Column1

COMPRESS returns

[4, 18, 36, null, 95][4, 18, 36, 95]
[33.7, 82.5, 126.02, 133.4, null][33.7, 82.5, 126.02, 133.4]
[Tue Aug 02 15:55:03 CEST 2011, null, Fri Oct 15 04:34:34 CEST 2010][Tue Aug 02 15:55:03 CEST 2011, Fri Oct 15 04:34:34 CEST 2010]
[true, false, false, null, true][true, false, false, true]
[Mike, John, Charles, null, Rob][Mike, John, Charles, Rob]