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: Table that contains the column whose unique values are to be returned
 Column Name
Column Name: Name of the column whose unique values are to be returned
 Sort Values
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
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
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.
Copyright © 2013
	 Software AG, Darmstadt, Germany and/or Software AG USA Inc., Reston, VA, USA, and/or Terracotta Inc., San Francisco, CA, USA, and/or Software AG (Canada) Inc., Cambridge, Ontario, Canada, and/or, Software AG (UK) Ltd., Derby, United Kingdom, and/or Software A.G. (Israel) Ltd., Or-Yehuda, Israel and/or their licensors.