Distinct Values
Returns a table with a single column that lists all unique values from a specified column of a specified table.
Arguments
This function has the following arguments:
Table: Table that contains the column whose unique values are to be returned
Column Name: Name of the column whose unique values are to be returned
Sort Values: Numeric value that controls whether the returned values are sorted. Set this to
1 in order to sort the values. Values are sorted in numerical order, if all values are numbers; otherwise they are sorted alphabetically.
Sort Descending: Numeric value that controls whether the returned values are sorted in descending order, if
Sort Values is set to
1. Set
Sort Descending to
1 in order to sort the values in descending order. Set the argument to
0 (or leave it blank) in order to sort the values in ascending order.
Use Column Name: Numeric value that controls the label of the returned column. Set this argument to
1 in order to use the original column name (the value of the
Column Name argument). Set the argument to
0 (or leave it blank) in order to use the name
Values. Use a generic name when you want a display that is independent of the value of
Table, for example, because the value of
Table uses a substitution that causes column names to change when the substitution changes.
This function returns a table.