The node behaves the same as a combination of the Sorter node followed by a Row Filter that only keeps the first k rows of the table except for the order of the rows which depends on the Output order settings. Note, however, that the implementation of this node is more efficient then the node combination above. In the dialog, select the columns according to which the data should be selected. For each column you can also specify whether a larger or smaller value is considered as superior.
Options
Settings
Advanced Settings
Popular Predecessors
- GroupBy12 %
- Sorter7 %
- Joiner6 %
- Group Loop Start4 %
Row Filter (deprecated)4 %- Math Formula3 %
- Rule-based Row Filter2 %
- Linear Correlation2 %
- Excel Reader2 %
- Files/Folders Meta Info2 %
- DB Reader1 %
Column Rename1 %Row Splitter (deprecated)1 %- Column Resorter1 %
- Network Analyzer1 %
- List Files/Folders1 %
- Association Rule Learner (Borgelt)1 %
- Concatenate< 1 %
Loop End< 1 %- Column Filter< 1 %
- Nominal Value Row Splitter< 1 %
- Reference Row Filter< 1 %
- Data Explorer< 1 %
- Rank< 1 %
- Shuffle< 1 %
- String Similarity< 1 %
- Table View (JavaScript)< 1 %
- Rule-based Row Splitter< 1 %
- Integer Widget< 1 %
- CSV Reader< 1 %
- Column Selection Widget< 1 %
- Add Empty Rows< 1 %
- Table Transposer< 1 %
- Column Expressions< 1 %
- JSON to Table< 1 %
- Date&Time Difference< 1 %
- String to Date&Time< 1 %
- Date&Time-based Row Filter< 1 %
- Number to String< 1 %
- String Manipulation< 1 %
- Extract Table Spec< 1 %
- Line Plot (JavaScript)< 1 %
- ROC Curve (JavaScript)< 1 %
- Column Renamer< 1 %
- Column Name Extractor< 1 %
- Duplicate Row Filter< 1 %
- Top k Row Filter< 1 %
- Rule Engine< 1 %
- Java Snippet Row Filter< 1 %
- Category to Number< 1 %
- Row Aggregator< 1 %
List Files< 1 %- Integer Configuration< 1 %
- Create Date&Time Range< 1 %
- Table Row to Variable< 1 %
- Loop End< 1 %
- Table Manipulator< 1 %
- Similarity Search< 1 %
- Interactive Range Slider Filter Widget< 1 %
- Column Selection Configuration< 1 %
File Reader< 1 %- Java Snippet< 1 %
Recursive Loop End< 1 %- Column Combiner< 1 %
- Nominal Value Row Filter< 1 %
Joiner< 1 %- Normalizer< 1 %
- Pivot< 1 %
- Missing Value< 1 %
- Number Rounder< 1 %
- Row Sampling< 1 %
- Unpivot< 1 %
- Rank Correlation< 1 %
- Empty Table Switch< 1 %
- IF Switch< 1 %
- DB Query Reader< 1 %
- Counter Generation< 1 %
- Math Formula (Multi Column)< 1 %
Excel Reader (XLS)< 1 %- Keygraph Keyword Extractor< 1 %
- Moving Aggregator< 1 %
- Numeric Scorer< 1 %
- Association Rule Learner< 1 %
- Subset Matcher< 1 %
- String Manipulation (Multi Column)< 1 %
- Chi-Square Keyword Extractor< 1 %
Cell Replacer< 1 %- Numeric Outliers< 1 %
- Random Forest Learner< 1 %
- String to Path (Variable)< 1 %
- Item Set Finder (Borgelt)< 1 %
- Column Splitter< 1 %
- File Meta Info (legacy)< 1 %
- Table Creator< 1 %
- Chunk Loop Start< 1 %
- Column List Loop Start< 1 %
- String to Number< 1 %
- Column Aggregator< 1 %
- Cross Joiner< 1 %
- Row Filter (Labs)< 1 %
- Reference Row Splitter< 1 %
- RowID< 1 %
- Ungroup< 1 %
- Value Counter< 1 %
- Rule Engine Variable< 1 %
- Statistics< 1 %
- End IF< 1 %
- File Reader< 1 %
- Table Row to Variable Loop Start< 1 %
- Case Converter< 1 %
- Column Appender< 1 %
- Constant Value Column< 1 %
- Scatter Plot (Plotly)< 1 %
- Math Formula (Variable)< 1 %
- Bag Of Words Creator< 1 %
- Integer Slider Configuration< 1 %
- Date&Time Part Extractor< 1 %
- CASE Switch Start< 1 %
- Counting Loop Start< 1 %
- String Manipulation (Variable)< 1 %
- Slider Widget< 1 %
- Python Script (legacy)< 1 %
- Generic Loop Start< 1 %
- Random Number Assigner< 1 %
- Edge Adjacency Matrix< 1 %
- RDKit Substructure Filter< 1 %
- Table Reader< 1 %
- Table to JSON< 1 %
- Keras Network Executor< 1 %
Recursive Loop Start< 1 %- Cell Splitter< 1 %
- Column Comparator< 1 %
- Variable Expressions< 1 %
- Date&Time to legacy Date&Time< 1 %
- Exploration/Exploitation Score Combiner< 1 %
Table Row to Variable< 1 %- Extract Table Dimension< 1 %
- Color Manager< 1 %
- Column Filter Configuration< 1 %
- String to Date/Time (legacy)< 1 %
- XPath< 1 %
- Filter Apply< 1 %
- Missing Value Column Filter< 1 %
- Partitioning< 1 %
- SDF Reader< 1 %
- Empty Table Creator< 1 %
- Meta Info Inserter< 1 %
- t-SNE (L. Jonsson)< 1 %
- Density Scorer< 1 %
CSV Reader< 1 %- Random Forest Predictor< 1 %
- Data Generator< 1 %
- Bubble Chart (Plotly)< 1 %
- Integer Input (legacy)< 1 %
- Heatmap (JavaScript)< 1 %
- Fingerprint Similarity< 1 %
- Feature Selection Loop End< 1 %
- Recursive Loop Start< 1 %
- Bootstrap Sampling< 1 %
- Numeric Row Splitter< 1 %
- String Replacer< 1 %
CASE Switch Data (Start)< 1 %- TF< 1 %
- String Matcher< 1 %
- Tag Cloud (JavaScript)< 1 %
- Column Filter Widget< 1 %
- Parameter Optimization Loop End< 1 %
- Fingerprint Similarity< 1 %
IF Switch (Flow Variable Value)< 1 %- Number Formatter< 1 %
- Copy/Move Files (legacy)< 1 %
Table Column to Variable< 1 %- Java Edit Variable< 1 %
Generic Loop Start< 1 %Scorer< 1 %- Entropy Scorer< 1 %
- Distance Matrix Pair Extractor< 1 %
Column Appender< 1 %- Column Rename (Regex)< 1 %
- Nominal Probability Distribution Splitter< 1 %
Color Appender< 1 %- Molecule Type Cast< 1 %
- k-Medoids< 1 %
- TensorFlow Network Executor< 1 %
- H2O to Table< 1 %
- H2O Random Forest Learner (Regression)< 1 %
- Topic Extractor (Parallel LDA)< 1 %
- NGram Creator< 1 %
- Value Filter (legacy)< 1 %
- String Input (legacy)< 1 %
- JSON Path< 1 %
- R to Table< 1 %
- Date&Time to String< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Element Filter< 1 %
Read MDB< 1 %- Hydrogen Remover< 1 %
Flow Variable End IF< 1 %- Fingerprint Similarity< 1 %
- Variable to Table Row< 1 %
Database Sorter< 1 %- Line Reader< 1 %
- Feature Selection Loop Start (1:1)< 1 %
Variable Loop End< 1 %- Fuzzy Rule Learner< 1 %
- Linear Regression Learner< 1 %
- Logistic Regression Predictor< 1 %
- Simple Regression Tree Predictor< 1 %
- Column Auto Type Cast< 1 %
- Category to Number (Apply)< 1 %
- Lag Column< 1 %
- Edit Numeric Domain< 1 %
- Double to Integer< 1 %
- Extract Missing Value Cause< 1 %
- Interactive HiLite Collector< 1 %
- Cache< 1 %
- Crosstab< 1 %
- Spark to Table< 1 %
- Parallel Chunk End< 1 %
- Snowball Stemmer< 1 %
- Tika Parser< 1 %
- Term to String< 1 %
- Column Filter (legacy)< 1 %
- Interactive Value Filter Widget< 1 %
- Container Input (Table)< 1 %
- Columns to JSON< 1 %
- Cell Clump Splitter (Deprecated)< 1 %
- Disturber Node< 1 %
Extract Date&Time Fields< 1 %- Time to String (legacy)< 1 %
- RDKit Canon SMILES< 1 %
- RDKit Diversity Picker< 1 %
- RDKit Optimize Geometry< 1 %
- Form Encoded HTTP Entity Creator< 1 %
Views
- This node has no views
Workflows
[Latest] Consolidated 3 Mar 1210KNIME Hub- 00_Topic_Modeling_with_Verified_ComponentsKNIME Hub
- 00_Topic_Modeling_with_Verified_ComponentsKNIME Hub
- 01 Bug Squashing PokemonKNIME Hub
- 01 Bug Squashing PokemonKNIME Hub
- Show all 670 workflows
Links
- NodePit, your search engine for KNIME nodes and workflowsby danielesser on 2019-12-08forum.knime.com/p/76442
- Extract last 5 recordsby HansS on 2020-03-29forum.knime.com/p/85709
- Counting from Top 5by HansS on 2020-07-15forum.knime.com/p/97009
- Filter nlargest of Groupby gonhaddock on 2022-04-08forum.knime.com/p/153272
Developers
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.