Min Columns
Returns a table that includes a column reflecting one of the smaller of two specified columns of a specified table, the smaller of a specified value and a specified column, or the smaller of two specified values.
Usage notes
Case 1: Smaller of two specified columns of a specified table. This is the case if
First Column Name or Numeric Value and
Second Column Name or Numeric Value both specify a column of
Table.
Case 2: Smaller of a specified value and a specified column. This is the case if one of
First Column Name or Numeric Value and
Second Column Name or Numeric Value specifies a column of
Table and the other specifies a numeric value.
Case 3: Smaller of two specified values. This is the case if
First Column Name or Numeric Value and
Second Column Name or Numeric Value both specify a numeric value.
In case 1, the nth cell in the returned column corresponds to the nth cell of the table specified by the argument Table. Each cell of the returned column contains the smaller of the corresponding row’s cell in First Column Name or Numeric Value and the cell in Second Column Name or Numeric Value.
In case 2, the nth cell in the returned column corresponds to the nth cell of the table specified by the argument Table. Each cell of the returned column contains the smaller of the corresponding row’s cell in the specified column and the specified numeric value.
In case 3, each cell of the returned column contains the smaller of the two specified numeric values.
In the returned table, the column that reflects the smaller value is preceded by copies of all the columns in Table.
Arguments
The function has the following arguments:
Table: Table that contains the columns to be compared.
First Column Name or Numeric Value: Text string specifying the first column to be compared, or numerical value to be compared.
Second Column Name or Numeric Value: Text string specifying the second column to be compared, or numerical value to be compared.
Result Column Name: Text string that specifies the name of the column containing the minimums. You must supply a value for this argument.
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.