Sort Table
Returns a table with the same rows as a specified table but with the rows sorted according to the values in a specified column or columns.
If you specify multiple columns, the returned table is sorted on the first column specified, and then on the second column, and so forth.
Arguments
This function has the following arguments:
Table: Table to sort.
Sort Column Name: Text string that specifies the column or columns whose values determine the sort order. Separate column names with a semicolon. If the columns contain text, the sort order is alphabetic, unless the text consists entirely of numbers, in which case the sort order is numeric.
Sort Descending: Numerical value (
0 or
1) that determines whether the sort order is ascending or descending. If set to
1, the sort order is descending; otherwise, the sort order is ascending.
Note: If an invalid column name is entered, the original table is returned.
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.