Difference between revisions of "Sort Data Table"

From PresenceWiki
Jump to: navigation, search
 
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:
  
http://www.international-presence.com/wikidocs/images/sort_table_dialog.png
+
[[file:sort_table_dialog.png]]
  
 
=== Sort Priority ===
 
=== Sort Priority ===

Latest revision as of 08: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 table dialog.png

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