Distinct

The Distinct() function returns a list of unique values from a provided list of values. The list must contain only values of the same type, and they may be numbers, dates, concepts, texts, yes/no booleans.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a collection of values where duplicates are filtered out of.

Syntax

Distinct(values)

Distinct( List(1,2,3,4,1,2,3,4) ) => 1, 2, 3, 4

Distinct([Products.Category] of [Products]) => Monitor, Phone, Printer (when all possible categories in list Products are one of these three values)

Distinct( List( "A", "a", "b", "B", "C", "C", "c") ) => A, b, C

Distinct() => Invalid expression

Parameters

Name	Type	Required	Description
values	list	☑️	a list of values or elements of the same type.