Sorter (Array Configurable)

Row Sorter using the standard Sorter node, but with dialog for configuration.

In KNIME 5.3, the ability to configure the node using arrays was deprecated, so this component encapsulates and exposes the old functionality via configuration fields thereby continuing to allow sorting to be configured programmatically.


@takbb Brian Bates

Options

Sort in memory

If selected the table is sorted in memory which requires more memory, but is faster. In case the input tableis large and memory is scarce it is recommended not to check this option

Move missing to end of sorted list

If selected missingvalues are always placed at the end of the sorted output. This isindependent of the sort order, i.e. if sorted ascendingly they areconsidered to be larger than a non-missing value and if sorted descendinglythey are smaller than any non-missing value.

Column List

Specify the variable containing the list of columns that form the basis of the sorting.

Sort Direction List

Specify the variable containing the sort-ordering list. This should have the same number of elements as the Column List, and should specify booleans true=Ascending, false=Descending for each column in the Column List

Alpha Numeric String Comparison

Specify the Array variable that defines if sorting of a column is alphanumeric sorting (true) or lexicographic (false). %%00010%%00010Alphanumeric: "Row2" before "Row10" Lexicographic: "Row10" before "Row2".

Nodes

• Rule Engine4 ×
• Column Selection Configuration3 ×
• Boolean Configuration2 ×
• Column Filter2 ×
• Table Row to Variable2 ×
• Column Appender1 ×
• Column Rename1 ×
• Column Rename (Regex)1 ×
• Component Input1 ×
• Component Output1 ×
• Constant Value Column1 ×
• GroupBy1 ×
• Java Edit Variable1 ×
• Merge Variables1 ×
• Sorter1 ×
• String Manipulation (Variable)1 ×
• Ungroup1 ×
• Variable to Table Row1 ×

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Javasnippet
• FeatureKNIME Quick Forms

Links

• No links available