Identifies the column or set of columns by which the dataset is sorted.
- Multiple column names can be separated by commas.
- Ranges of columns cannot be specified.
The order can be reversed by adding a negative sign in front of the column name:Multi-column sorts: You can also specify multi-column sorts. The following example sorts first by the inverse order of
ProductName, and within that sort, rows are sorted by
ProductColor: Sort by original row numbers: As an input value, this parameter also accepts the
SOURCEROWNUMBERfunction, which performs the sort according to the original order of rows when the dataset was created. See SOURCEROWNUMBER Function.
This page has no comments.