COMPRESS

Owned by Charles Bishop (Deactivated)
Jan 30, 2018
1 min read

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]