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 following names. An unrecognized value causes this function to return "?".

Supported names for locale parameter

Arabic

English

Hindi

Norwegian

Spanish_Traditional

Bengali

Estonian

Hungarian

Panjabi

Swedish

Bulgarian

Finnish

Icelandic

Persian

Swedish_Custom

Catalan

Finnish_Custom

Italian

Polish

Tamil

Catalog

French

Japanese

Portuguese

Telugu

Chinese

German

Kannada

Romanian

Thai

Chinese_Stroke

German_Dictionary

Korean

Russian

Turkish

Croatian

Greek

Latvian

Serbian

Ukrainian

Czech

Greek_Mixed

Lithuanian

Slovak

Unicode_Raw

Danish

Gujarati

Malayalam

Slovenian

Unicode_Standard

Dutch

Hebrew

Marathi

Spanish

Vietnamese

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

Related topics