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:
| Transformation Name | Sort rows |
|---|---|
| Parameter: Sort by | -ProductName |
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:
| Transformation Name | Sort rows |
|---|---|
| Parameter: Sort by | -ProductName,ProductColor |
Sort by original row numbers: As an input value, this parameter also accepts the SOURCEROWNUMBER function, which performs the sort according to the original order of rows when the dataset was created.
| Transformation Name | Sort rows |
|---|---|
| Parameter: Sort by | $sourcerownumber |
This page has no comments.