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 Successors
- Concatenate5 %
- Column Filter5 %
- Table Row to Variable5 %
- Excel Writer4 %
- Joiner4 %
- Loop End3 %
- Sorter3 %
- Bar Chart2 %
- GroupBy2 %
- Reference Row Filter2 %
- Python Script (legacy)1 %
Table Row To Variable Loop Start1 %- Table Row to Variable Loop Start1 %
Row Filter (deprecated)1 %- CSV Writer< 1 %
- Object Inserter< 1 %
- Cross Joiner< 1 %
- DB Writer< 1 %
- Constant Value Column< 1 %
- String Manipulation< 1 %
- Column Renamer (Dictionary)< 1 %
Joiner< 1 %- Column Expressions< 1 %
- Rule-based Row Filter< 1 %
- Math Formula< 1 %
Excel Sheet Appender (XLS)< 1 %- Column Appender< 1 %
Column Rename< 1 %- Tag Cloud (JavaScript)< 1 %
Table Column to Variable< 1 %Loop End< 1 %- Chunk Loop Start< 1 %
- Value Lookup< 1 %
- Rule Engine< 1 %
- Pie Chart< 1 %
- DB Loader< 1 %
- Parameterized DB Query Reader< 1 %
- DB Update< 1 %
- HTTP Retriever< 1 %
- String to Number< 1 %
- Reference Row Splitter< 1 %
- Missing Value< 1 %
- RowID< 1 %
- GroupBy Bar Chart (JFreeChart)< 1 %
- Line Plot (JavaScript)< 1 %
- k-Means< 1 %
- Column Resorter< 1 %
- Reference Column Splitter< 1 %
- Pivot< 1 %
- Rank< 1 %
- Top k Row Filter< 1 %
- CASE Switch End< 1 %
- Box Plot< 1 %
- Table View< 1 %
- Loop End (Column Append)< 1 %
- Recursive Loop End< 1 %
- Cell Splitter< 1 %
- Column Splitter< 1 %
- Rule-based Row Splitter< 1 %
- Color Manager< 1 %
- Interactive Table (legacy)< 1 %
- Cell to Model< 1 %
- Term to String< 1 %
- Weka Predictor (3.7)< 1 %
- Date&Time Part Extractor< 1 %
- Wait...< 1 %
Database Looping< 1 %- Table Writer< 1 %
- Java Snippet< 1 %
Scorer< 1 %Cell Replacer< 1 %- Domain Calculator< 1 %
Row Splitter (deprecated)< 1 %- Table Difference Finder< 1 %
- CASE Switch Start< 1 %
- End IF< 1 %
- Line Plot< 1 %
- SDF Writer< 1 %
- DB Insert< 1 %
- Math Formula (Multi Column)< 1 %
- OSM Map View< 1 %
Excel Writer (XLS)< 1 %- Send to Power BI< 1 %
- Heatmap (JavaScript)< 1 %
- Table View (JavaScript)< 1 %
- R View (Table)< 1 %
- DELETE Request< 1 %
- POST Request< 1 %
- Date&Time Shift< 1 %
- XLS Control Table from Cell Range< 1 %
- Message Slack channel< 1 %
- Table To Excel Cell Updater< 1 %
- Breakpoint< 1 %
- Catch Errors (Data Ports)< 1 %
Table Column to Variable< 1 %- Table Column to Variable< 1 %
CSV Writer< 1 %- Group Loop Start< 1 %
- Cell Splitter By Position< 1 %
- Number to String< 1 %
- Column Renamer< 1 %
Column Appender< 1 %- Column Name Extractor< 1 %
- Duplicate Row Filter< 1 %
- Reference Column Filter< 1 %
- Missing Value Column Filter< 1 %
- Table Manipulator< 1 %
- Partitioning< 1 %
- Reference Column Resorter< 1 %
- Number Rounder< 1 %
- Row Aggregator< 1 %
- String Manipulation (Multi Column)< 1 %
- String Replacer< 1 %
- Table Transposer< 1 %
- Ungroup< 1 %
- Unpivot< 1 %
- Value Counter< 1 %
- Extract Table Dimension< 1 %
- Extract Table Spec< 1 %
- Interactive Histogram (legacy)< 1 %
- Pie chart (legacy)< 1 %
- Interactive Pie chart (legacy)< 1 %
- Heatmap< 1 %
- DB Merge< 1 %
- Counter Generation< 1 %
- Similarity Search< 1 %
- Bar Chart (JavaScript)< 1 %
- Bubble Chart (Plotly)< 1 %
Send to Power BI< 1 %- Java Snippet (simple)< 1 %
- Strings to Document< 1 %
- Path to String< 1 %
- String to Path< 1 %
- Google Sheets Updater< 1 %
- Scatter Plot (JavaScript)< 1 %
- Interactive Range Slider Filter Widget< 1 %
- Table to JSON< 1 %
- Data to Report (BIRT)< 1 %
- GET Request< 1 %
- Date&Time Difference< 1 %
- Date&Time to String< 1 %
- String to Date&Time< 1 %
- Modify Time Zone< 1 %
- Moving Average< 1 %
- Latitude/Longitude to Coordinate< 1 %
- Variable to Table Column< 1 %
Table Row to Variable< 1 %- Random Forest Predictor (Regression)< 1 %
- Column Aggregator< 1 %
- Parallel Chunk Start< 1 %
- Variable Expressions< 1 %
Excel Writer (XLS)< 1 %- Meta Info Inserter< 1 %
- Document Viewer< 1 %
- Tagged Document Viewer< 1 %
- Generic JavaScript View (JavaScript)< 1 %
- Container Output (JSON)< 1 %
- R Snippet< 1 %
Auto Active Learn Loop End< 1 %- Density Scorer< 1 %
- Try (Variable Ports)< 1 %
- Inject Variables (Data)< 1 %
Variable Condition Loop End< 1 %- Generic Loop Start< 1 %
- Decision Tree Learner< 1 %
- Linear Regression Learner< 1 %
- Scorer< 1 %
- Column Rename (Regex)< 1 %
- Nominal Value Row Filter< 1 %
- Row Sampling< 1 %
- Renderer to Image< 1 %
- DB SQL Executor< 1 %
- Geo-Coordinate Row Filter< 1 %
- Java IF (Table)< 1 %
- Tags to String< 1 %
- Tag Cloud< 1 %
- Table Difference Checker< 1 %
- Table to HTML String< 1 %
- String to URI< 1 %
Database Update< 1 %- Column List Loop Start< 1 %
- SVM Predictor< 1 %
- Column Merger< 1 %
- Double to Integer< 1 %
- Normalizer< 1 %
- Set Operator< 1 %
- Shuffle< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- TimeDelay Loop Start< 1 %
- Line Plot (Plotly)< 1 %
- Bubble Chart (JFreeChart)< 1 %
- Dictionary Tagger< 1 %
- Column Selection Configuration< 1 %
- Value Selection Configuration< 1 %
- JSON Path< 1 %
- Add Table to R< 1 %
- Webpage Retriever< 1 %
- Result< 1 %
- Tautomer Generator< 1 %
- Save File Locally< 1 %
- Spell Checker (simple)< 1 %
- Pareto Ranking< 1 %
- Active Learn Loop End (Legacy)< 1 %
- Active Learning Loop End< 1 %
- Create Collection Column< 1 %
- Split Collection Column< 1 %
- Copy/Move Files (legacy)< 1 %
- Upload (legacy)< 1 %
- Extract Variables (Data)< 1 %
Table Row to Variable< 1 %Image Writer (Table Column)< 1 %- CSV Reader< 1 %
Recursive Loop Start< 1 %- PNN Predictor< 1 %
- Fuzzy c-Means< 1 %
- DBSCAN< 1 %
- K Nearest Neighbor< 1 %
- RProp MLP Learner< 1 %
- Logistic Regression Predictor< 1 %
- Numeric Scorer< 1 %
- Add Empty Rows< 1 %
- Lag Column< 1 %
- Equal Size Sampling< 1 %
- Row Filter (Labs)< 1 %
- Number to String (PMML)< 1 %
- String Splitter (Regex)< 1 %
- Data Explorer< 1 %
- Numeric Outliers< 1 %
- Statistics< 1 %
CASE Switch Data (End)< 1 %- IF Switch< 1 %
CASE Switch Data (Start)< 1 %- Crosstab< 1 %
- Histogram (legacy)< 1 %
Color Appender< 1 %- ROC Curve (legacy)< 1 %
Parquet Writer< 1 %- Molecule Type Cast< 1 %
- SDF Extractor< 1 %
- DB Delete (Table)< 1 %
- DB Row Sampling< 1 %
DB Table Creator< 1 %- String Distances< 1 %
- 2D Density Plot (Plotly)< 1 %
- Scatter Plot (Plotly)< 1 %
- Stacked Area Chart (Plotly)< 1 %
- External Tool< 1 %
Excel Sheet Appender (XLS)< 1 %- Send to Tableau Server< 1 %
- Frequency Filter< 1 %
- TF< 1 %
- String Matcher< 1 %
- Tika Parser URL Input< 1 %
- Case Converter< 1 %
- Stanford Lemmatizer< 1 %
- POS Tagger< 1 %
- Document Vector< 1 %
- String to Path (Variable)< 1 %
- Value Selection (legacy)< 1 %
- ROC Curve (JavaScript)< 1 %
- Table Editor (JavaScript)< 1 %
- Tile View (JavaScript)< 1 %
- Column Filter Widget< 1 %
- Container Output (Table)< 1 %
- XML to JSON< 1 %
- JSON Transformer< 1 %
- LIME Loop Start< 1 %
- SubGraph Extractor< 1 %
Python Script (1⇒1)< 1 %- PUT Request< 1 %
- Date&Time to legacy Date&Time< 1 %
- Date Field Extractor (legacy)< 1 %
- Time to String (legacy)< 1 %
- RDKit From Molecule< 1 %
- HTML Parser< 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 671 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.