Sort

From Clariopedia

Contents 1 Overview 2 Usage 2.1 Input Stream 2.2 Configuration 2.2.1 Select Attributes 2.2.2 Define Sort Order 2.3 Field Definitions 2.4 Results 2.5 Output Stream 3 Video Demonstration 4 References

Overview

The clario^® node Sort is used to sort data by a given attribute or attributes in ascending or descending order where the given attributes can be either numeric or string.

Usage

Input Stream

The node connector can be connected to a variety of nodes, (ie. Read, Outliers, Missing, etc.), but requires a valid stream of data.

Configuration

The Sort node has two configuration faces, select attributes and define sort order.

Select Attributes

The Select Attributes face contains an Available Attributes and a Selected Attributes list box. The Available Attributes list box displays all of the attributes for the input data stream connected to the input link node connector. The first and only step is to select, drag and drop the desired attributes to sort the data from the Available Attributes list box to the Selected Attributes list box. Data will be sorted based on the order of the selected attributes. For example the data will first be sorted by the first attribute listed, and then the data will be sorted within each value of the first attribute by the next selected attribute, and so on. NOTES: All attributes are passed through the sort node, including those attributes used in the sort.

Define Sort Order

On the Define Sort Order configuration face, select whether you want the data sorted in ascending or descending order based on the value of the attribute you selected for every attribute listed. The default sort order is ascending.

Notes: To efficiently find attribute names, begin typing an attribute name in the text box directly above the Available Attributes box. You will then be directed to only the attribute(s) beginning with the letter(s) you type. To select multiple attributes at once: [Ctrl]+click multiple attributes to select them one at a time; press [Shift]+down arrow after selecting one attribute to select multiple attributes in order of appearance; or select a block of attributes by clicking the first attribute and then [Shift]+click the last attribute. Then drag selections to the Selected Attributes box. To de-select an attribute click on the attribute in the Selected Attributes box and drag and drop into the Available Attributes box. Attributes in the Selected Attributes list can be re-ordered by clicking and holding on an attribute and dragging it to the desired position within the Selected Attributes box.

Field Definitions

• Valid Inputs – You must link to a valid data stream (ie. Read, Missing, Outliers, etc.).

• Available values in the drop-down are <ASCENDING> and <DESCENDING>.
• Default value for the drop-down is <ASCENDING>.
• At least 1 attribute must be placed in the "Selected Attributes" list.
• Attributes from the "Selected Attributes" list on the select attributes configuration face populate the "Attribute" column on the define sort order configuration face.

Results

There is no results face for the Sort node. It is assumed the Sort node will be connected to another node that requests or requires sorted data.

Output Stream

Due to the unique design of clario, where data is streamed throughout all processing, the new 'sorted' dataset is ready for immediate use through various nodes. The data can also be exported using the Write File node and can then be used again by reading in the file with the Read File node.

Video Demonstration

References

None.