distinctWithNull

Returns the distinct values of the list. If the list has at least one null value, a null value will be in the returned list.

Category

List

Function syntax

distinctWithNull(<parameter>)

Parameters

Signatures and returned types

distinctWithNull(<listInteger>)

Returns a list of integers.

distinctWithNull(<listDecimal>)

Returns a list of decimals.

distinctWithNull(<listString>)

Returns a list of strings.

distinctWithNull(<listDateTimeOnly>)

Returns a list of datetimes without considering time zone.

distinctWithNull(<listDateTime>)

Returns a list of datetimes.

distinctWithNull(<listDateOnly>)

Returns a list of dates.

distinctWithNull(<listBoolean>)

Returns a list of booleans.

distinctWithNull(<listDuration>)

Returns a list of durations.

Examples

distinctWithNull([10,2,10,null])

Returns [10, 2, null]