Page tree



Contents:

The cloud-based version of Trifacta Wrangler is now available! Read all about it, and 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.

Your Rating: Results: 1 Star2 Star3 Star4 Star5 Star 13 rates

This page has no comments.