Page tree

The cloud-based product Trifacta Free is available now! Register for your free account.

 

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

See SOURCEROWNUMBER Function.

This page has no comments.