List.RemoveNulls

  • Article

Syntax

List.RemoveNulls(list as list) as list

About

Removes all occurrences of "null" values in the list. If there are no 'null' values in the list, the original list is returned.

Example 1

Remove the "null" values from the list {1, 2, 3, null, 4, 5, null, 6}.

Usage

List.RemoveNulls({1, 2, 3, null, 4, 5, null, 6})

Output

{1, 2, 3, 4, 5, 6}