Difference between revisions of "Sort Data Table"
Line 1: | Line 1: | ||
The Sort Data Table node reorders the rows in the current [[Data Table]] in ascending or descending order of the values of the columns contained. Below is the dialog box that is presented when dragging a Sort Data Table Node into your Task: | The Sort Data Table node reorders the rows in the current [[Data Table]] in ascending or descending order of the values of the columns contained. Below is the dialog box that is presented when dragging a Sort Data Table Node into your Task: | ||
− | + | [[file:sort_table_dialog.png]] | |
=== Sort Priority === | === Sort Priority === |
Latest revision as of 12:44, 21 August 2015
The Sort Data Table node reorders the rows in the current Data Table in ascending or descending order of the values of the columns contained. Below is the dialog box that is presented when dragging a Sort Data Table Node into your Task:
Sort Priority
In order to add a Column for consideration, drag it from the list of available columns on the left into the table on the right. Columns with a higher priority (at the top of the table) will be used first for sorting the table. If values are equal the next column will be considered, and if those values are also equal the third column will be considered - and so on.
For example, consider the following Table, before and after sorting on the AGE and SURNAME columns (in that order):
FORENAME | SURNAME | AGE |
---|---|---|
Adrian | Smith | 37 |
Mark | Townsend | 34 |
Susan | Jerone | 33 |
Lisa | Coultier | 34 |
Albert | Petersson | 37 |
FORENAME | SURNAME | AGE |
---|---|---|
Susan | Jerone | 33 |
Lisa | Coultier | 34 |
Mark | Townsend | 34 |
Albert | Petersson | 37 |
Adrian | Smith | 37 |
As you can see the second column (SURNAME) is only considered if the first column (AGE) is identical.
Data Filter | Require Columns | Append Data Column | Multiple Column Appender
Drop Column | Drop Row(s) | Calculate Column Aggregate | Dataset Splitter | Merge Data
Create Data Table | Clear Data Table | Sort Data Table | Drop Duplicate Rows | Store Data Table | Retrieve Data Table
Task Elements > Data Table Nodes > Sort Data Table