UniqueValues

Returns unique values that are in a list based on the specified data type and locale.

Format 

UniqueValues ( values {; datatype ; locale } )

Parameters 

values - any text expression or field that's a list of values separated by carriage returns.

datatype - a number that specifies the type of data in values (see below).

locale - the name of the locale of the data in values (see below).

Parameters in braces { } are optional.

Data type returned 

text

Originated in version 

16.0

Description 

For a description of a list of values, see ValueCount function.

Each returned value ends with a carriage return, allowing lists to be easily concatenated.

For the datatype parameter, use one of the following values.

datatype option

Data type

1

Text

2

Number

3

Date

4

Time

5

Timestamp

For the locale parameter, use one of the names in Language names for sorting and indexing. An unrecognized value causes this function to return "?".

Notes 

  • The datatype and locale parameters affect only how this function determines uniqueness; the data is not sorted. Uniqueness is determined in the same manner as for indexing. See Choosing a language for indexing or sorting.

  • If you set the locale parameter to Unicode_Raw, this function will distinguish between values based on their Unicode numeric encoding, which for example, differentiates between characters with different case and diacritical marks.

Example 1 

UniqueValues ( "34¶600¶18¶600¶18.0" ; 2 ) returns 34¶600¶18¶.

Example 2 

UniqueValues ( Product::Colors ) removes duplicates based on the default data type of text in a file in which the locale is English:

RED¶green¶yellow¶

when the Product::Colors field contains RED¶green¶red¶yellow¶.