Sort Transform

sort order:LastName

Output: Dataset is sorted in alphabetically ascending order based on the values in the LastName column, assuming that the values are strings.

sort order:column_ref

For more information on syntax standards, see Language Documentation Syntax Notes.

Identifies the column or set of columns by which the dataset is sorted.

The order can be reversed by adding a negative sign in front of the column name:

-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:

-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.

$sourcerownumber

See SOURCEROWNUMBER Function.

Usage Notes:

Data is sorted based on the data type of the source:

Source:

The column without a name identifies the original row numbers. In the data grid, this information is available when you hover over the black dot to the left of a row of data.

Transformation:

First, you might want to clean up the number formatting in the lastOrder column. The following formats the values to always include two digits after the decimal point:

LastOrder

numformat(LastOrder, '####.00')

Now, you're interested in the highest value for your customers' most recent orders. You can apply the following sort:

-LastOrder

Rows are sorted by the LastOrder column in descending order (largest to smallest):

The above row numbers represent the original order of the rows.Now, you want to get your data geographically organized by sorting by city and state. You can perform multi-column sorts such as the following, which sorts first by State and then by City columns:

State,City

In the generated output, the data is first sorted by the State value. Each set of rows within the same State value is also sorted by the City value.

This example illustrates how you can rename columns based on the contents of specified rows.

Source:

You have imported the following racer data on heat times from a CSV file. When loaded in the Transformer page, it looks like the following:

In the above, the (rowId) column references the row numbers displayed in the data grid; it is not part of the dataset. This information is available when you hover over the black dot on the left side of the screen.

Transformation:

You have examined the best performance in each heat according to the sample. You then notice that the data contains headers, but you forget how it was originally sorted. The data now looks like the following:

You can use the following transformation to use the third row as your header for each column:

Use row(s) as column names

Use a single row to name columns

3

Results:

After you have applied the above transformation, your data should look like the following: