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 .
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
