Reference > Functions reference > Text functions > UniqueValues
 

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 

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

The datatype and locale parameters work the same as those of the SortValues function, except that they 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.

Notes 

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.

This function is not supported in runtime solutions and returns "?".

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 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas

SortValues function