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