distinctWithNull distinctWithNull

Returns the distinct values or objects of a given list. If the list has at least one null entry, a null entry will be present in the returned list.

Note that the parameter <listObject> is not supported in this function.

Category

List

Function syntax

distinctWithNull(<parameters>)

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]