This node assigns ranks to rows based on user-defined ordering criteria. The ranking is determined by selecting one or more columns, with the option to specify ascending or descending order. If multiple criteria are set, the table is first sorted by the primary criterion, and subsequent criteria are used only in the case of ties.
Additionally, ranking can be performed within groups by selecting one or more category columns, where each unique combination of category values defines a separate ranking group.
Options
Popular Successors
Row Filter (deprecated)13 %- Rule-based Row Filter11 %
- Joiner7 %
- Sorter4 %
- Math Formula3 %
- GroupBy3 %
- Rule Engine3 %
- Column Filter2 %
- Rank2 %
- Column Resorter2 %
- Column Expressions (legacy)2 %
- Pivot2 %
- Excel Writer2 %
- String Manipulation2 %
Column Rename1 %Rank Correlation1 %- Concatenate< 1 %
Row Splitter (deprecated)< 1 %- Rule-based Row Splitter< 1 %
- Loop End< 1 %
- Duplicate Row Filter< 1 %
- Line Plot (legacy)< 1 %
- Lag Column< 1 %
String To Number< 1 %- R Snippet< 1 %
Concatenate (Optional in)< 1 %- Number to String< 1 %
- Constant Value Column< 1 %
Joiner< 1 %- Java Snippet (simple)< 1 %
Table Writer< 1 %- Moving Aggregator< 1 %
Cell Replacer< 1 %- String to Number< 1 %
Excel Sheet Appender (XLS)< 1 %Table Row to Variable< 1 %- Group Loop Start< 1 %
Column Appender< 1 %- Filter Apply< 1 %
- Row Filter (Labs)< 1 %
- Top k Row Filter< 1 %
- Interactive Table (legacy)< 1 %
- Date&Time Part Extractor< 1 %
- CSV Writer< 1 %
- Add Empty Rows< 1 %
- Column Combiner< 1 %
- Column Comparator< 1 %
Linear Correlation< 1 %- RowID< 1 %
- R View (Table)< 1 %
- Date&Time-based Row Filter< 1 %
- IF Switch< 1 %
- Molecule Type Cast< 1 %
Excel Sheet Appender (XLS)< 1 %- Table Writer< 1 %
- Loop End (Column Append)< 1 %
Recursive Loop Start (2 ports)< 1 %- Column Auto Type Cast< 1 %
- Linear Correlation< 1 %
- Reference Column Resorter< 1 %
- Statistics View< 1 %
Excel Writer (XLS)< 1 %- Tableau Writer< 1 %
- Table View (JavaScript) (legacy)< 1 %
- JChem Update< 1 %
- Variable to Table Column< 1 %
Loop End< 1 %Counting Loop Start< 1 %Recursive Loop Start< 1 %- Linear Regression Learner< 1 %
- Column Name Replacer< 1 %
- Subset Matcher< 1 %
- Normalizer< 1 %
- Value Counter< 1 %
- Rank Correlation< 1 %
- Numeric Outliers< 1 %
- End IF< 1 %
- Lift Chart (legacy)< 1 %
- Scatter Plot (legacy)< 1 %
- Pie Chart< 1 %
- Scatter Plot (Plotly)< 1 %
Excel Writer (XLS)< 1 %Date&Time to String< 1 %Modify Time< 1 %- String Similarity< 1 %
- Range Filter< 1 %
Table Column to Variable< 1 %- Table Row to Variable< 1 %
CSV Writer< 1 %Database Update< 1 %Database Looping< 1 %Database Connector< 1 %Database Table Creator< 1 %- Image Writer (Table)< 1 %
- Java Snippet< 1 %
- Counting Loop Start< 1 %
- Chunk Loop Start< 1 %
- Column List Loop Start< 1 %
- Recursive Loop Start< 1 %
- Table Row to Variable Loop Start< 1 %
Naive Bayes Learner< 1 %- k-Means< 1 %
Scorer< 1 %- Numeric Scorer< 1 %
- Auto-Binner< 1 %
- Numeric Binner< 1 %
- Bootstrap Sampling< 1 %
- Cell Splitter< 1 %
- Category to Number< 1 %
- Column Renamer< 1 %
- Column Aggregator< 1 %
- Column Appender< 1 %
- Column Renamer (Dictionary)< 1 %
- Cross Joiner< 1 %
- Double to Integer< 1 %
- Equal Size Sampling< 1 %
- Nominal Value Row Filter< 1 %
- Nominal Value Row Splitter< 1 %
- Reference Row Filter< 1 %
- Table Manipulator< 1 %
- Table Partitioner< 1 %
- Missing Value< 1 %
- Number to String (PMML)< 1 %
- Number Rounder< 1 %
- Numeric Row Splitter< 1 %
- Row Sampler< 1 %
- Shuffle< 1 %
Column Splitter< 1 %- String Manipulation (Multi Column)< 1 %
- Table Cropper< 1 %
- Table Difference Finder< 1 %
- Table Transposer< 1 %
- Ungroup< 1 %
- Unpivot< 1 %
- Value Lookup< 1 %
- Rule Engine (Dictionary)< 1 %
- Statistics< 1 %
- Extract Table Dimension< 1 %
- Crosstab< 1 %
- Color Manager< 1 %
- Bar Chart< 1 %
- Scatter Plot< 1 %
- Table View< 1 %
- DB Insert< 1 %
- DB Writer< 1 %
- DB Table Creator< 1 %
- Counter Generation< 1 %
- One Row to Many< 1 %
- Math Formula (Multi Column)< 1 %
- Math Formula (Variable)< 1 %
- Histogram Chart (JFreeChart)< 1 %
- Line Chart (JFreeChart)< 1 %
- Scatter Plot (JFreeChart)< 1 %
Send to Tableau Server (Hyper)< 1 %- Heatmap (JavaScript) (legacy)< 1 %
- Line Plot (JavaScript) (legacy)< 1 %
- Scatter Plot (JavaScript) (legacy)< 1 %
- Value Selection Widget< 1 %
- Python Script (legacy)< 1 %
- Data to Report (BIRT)< 1 %
Date&Time Difference< 1 %- Legacy Date&Time to Date&Time< 1 %
String to Date&Time< 1 %Date&Time Shift< 1 %- Moving Average< 1 %
- 3D Viewer< 1 %
- 2D/3D Scatterplot< 1 %
Element Selector< 1 %- Decision Tree Learner< 1 %
- Regression Predictor< 1 %
- Ruleset Predictor< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Parallel Chunk End< 1 %
- Similarity Search< 1 %
- Pie Chart (JFreeChart)< 1 %
- Table Indexer< 1 %
XLS Sheet Appender< 1 %- Value Filter (legacy)< 1 %
- Table to JSON< 1 %
- Count Execution Programmatically< 1 %
- String to Date/Time (legacy)< 1 %
Ranking Services< 1 %- Outlier Removal< 1 %
- R Plot< 1 %
- Split Collection Column< 1 %
Table Row To Variable Loop Start< 1 %Loop End (2 ports)< 1 %Variable Condition Loop End< 1 %Generic Loop Start< 1 %- Polynomial Regression Learner< 1 %
- Binner (Dictionary)< 1 %
- Column Merger< 1 %
- Column to Grid< 1 %
- HiLite Row Splitter< 1 %
- String Replacer< 1 %
- One-way ANOVA< 1 %
- SDF Writer< 1 %
- GroupBy Bar Chart (JFreeChart)< 1 %
- Bubble Chart (JFreeChart)< 1 %
- Lift Chart (JavaScript) (legacy)< 1 %
Extract Date&Time Fields< 1 %- Molecule Properties< 1 %
- TIBCO Spotfire File Writer< 1 %
- Total Count< 1 %
Loop End (3 ports)< 1 %- Table to Image< 1 %
- X-Partitioner< 1 %
- Fuzzy c-Means< 1 %
- Hierarchical Clustering< 1 %
- K Nearest Neighbor< 1 %
- Logistic Regression Predictor< 1 %
Regression Predictor< 1 %- Association Rule Learner< 1 %
- Simple Regression Tree Predictor< 1 %
Cell Splitter< 1 %- Edit Nominal Domain< 1 %
Column Filter< 1 %- Denormalizer< 1 %
String Replace (Dictionary)< 1 %- Independent groups t-test< 1 %
- CASE Switch Start< 1 %
- Cache< 1 %
- Extract Table Spec< 1 %
- Conditional Box Plot (legacy)< 1 %
- Histogram (legacy)< 1 %
- Parallel Coordinates (legacy)< 1 %
Color Appender< 1 %- String Distances< 1 %
- Line Plot (Plotly)< 1 %
- Bar Chart (JFreeChart)< 1 %
- HeatMap (JFreeChart)< 1 %
- OSM Map View< 1 %
- Excel Reader< 1 %
- Radar Plot Appender< 1 %
Document Data Extractor< 1 %- Term Vector< 1 %
- Column Filter (legacy)< 1 %
- Table Editor (JavaScript) (legacy)< 1 %
- Tile View (JavaScript) (legacy)< 1 %
- Feature Inserter< 1 %
- Date/Time Shift (legacy)< 1 %
- XPath< 1 %
- RDKit Find Murcko Scaffolds< 1 %
- Canonical SMILES< 1 %
- Customer Distributions< 1 %
- Range Splitter< 1 %
- BinningAnalysis< 1 %
- Normalize Plates (Z-Score)< 1 %
- R Snippet< 1 %
- Desirability Ranking< 1 %
- Pareto Ranking< 1 %
- Virtual Screening Metrics< 1 %
Graph Density Uncertainty Scorer< 1 %- ARIMA Learner< 1 %
- ARIMA Visualization< 1 %
- Create Collection Column< 1 %
- Extract URI Info< 1 %
Variable to Table Column< 1 %- Extract Variables (Data)< 1 %
- Inject Variables (Data)< 1 %
Table Row to Variable< 1 %Variable to Table Row< 1 %Database Writer< 1 %List Files< 1 %- Feature Selection Loop Start (1:1)< 1 %
Interval Loop Start< 1 %- Variable Condition Loop End< 1 %
Table Row To Variable Loop Start< 1 %Naive Bayes Predictor< 1 %- PNN Learner (DDA)< 1 %
- Cluster Assigner< 1 %
Logistic Regression Learner< 1 %Numeric Scorer< 1 %- SVM Predictor< 1 %
Random Forest Predictor (Regression)< 1 %- Create Bit Vector< 1 %
- Case Converter< 1 %
- Cell Splitter By Position< 1 %
- Number to Category (Apply)< 1 %
Number To String< 1 %- Column Name Extractor< 1 %
- Many to One< 1 %
- One to Many< 1 %
- Domain Calculator< 1 %
- Edit Numeric Domain< 1 %
- Extract Missing Value Cause< 1 %
- Reference Column Filter< 1 %
- Filter Apply Row Splitter< 1 %
- Missing Value Column Filter< 1 %
- Reference Row Splitter< 1 %
- String Splitter (Regex)< 1 %
- Set Operator< 1 %
- String Manipulation (Variable)< 1 %
- Target Shuffling< 1 %
- Data Explorer< 1 %
- Kruskal-Wallis Test< 1 %
CASE Switch Variable (End)< 1 %- Empty Table Switch< 1 %
- Timer Info< 1 %
- HiLite Table (legacy)< 1 %
- Interactive Histogram (legacy)< 1 %
- Pie chart (legacy)< 1 %
- Interactive Pie chart (legacy)< 1 %
- Box Plot (legacy)< 1 %
- Scatter Matrix (legacy)< 1 %
- Size Manager< 1 %
- ROC Curve (legacy)< 1 %
- Destroy Spark Context< 1 %
- DB Loader< 1 %
- DB Update< 1 %
DB Table Creator< 1 %- One Rule Inserter< 1 %
- Random Item Inserter< 1 %
- Stresser< 1 %
- Bit Vector Distances< 1 %
- Table to PMML Ensemble< 1 %
XLS Writer< 1 %Send to Power BI< 1 %- Send to Power BI< 1 %
- Java Snippet Row Filter< 1 %
- Java Snippet Row Splitter< 1 %
Tableau Writer (Hyper)< 1 %- Word Vector Apply (legacy)< 1 %
- String Matcher< 1 %
- Replacer< 1 %
- Dictionary Tagger< 1 %
- Bag Of Words Creator< 1 %
Document vector< 1 %- Document Vector< 1 %
- Strings to Document< 1 %
- String to Term< 1 %
- Term to String< 1 %
- Document Viewer< 1 %
- Tag Cloud< 1 %
- String to Path< 1 %
- Google Sheets Updater< 1 %
- Text Output (legacy)< 1 %
- Column Selection (legacy)< 1 %
- Generic JavaScript View (JavaScript) (legacy)< 1 %
- Tag Cloud (JavaScript) (legacy)< 1 %
- Object Inserter< 1 %
- Matrix to Network< 1 %
- Rowset Filter< 1 %
Python Script (1⇒1)< 1 %Python Script (2⇒1)< 1 %Python Script (2⇒2)< 1 %- Python View (legacy)< 1 %
- GET Request< 1 %
- Table Difference Checker< 1 %
Create Date&Time Range< 1 %- Time Difference (legacy)< 1 %
- Date Field Extractor (legacy)< 1 %
- Mask Date/Time (legacy)< 1 %
- Table to HTML String< 1 %
- RDKit Molecule Highlighting< 1 %
Views
- This node has no views
Workflows
00_KNIME_Workshop_basicsKNIME Hub- 00_Topic_Modeling_with_Verified_ComponentsKNIME Hub
- 00_Topic_Modeling_with_Verified_ComponentsKNIME Hub
- 01_Guided_AnalyticsKNIME Hub
- 01_Guided_AnalyticsKNIME Hub
- Show all 496 workflows
Links
- How can I generate sequence numbers?by izaychik63 on 2019-06-18forum.knime.com/p/62424
- row counter over partitionsby HansS on 2021-08-12forum.knime.com/p/131705
- Incremental count restarting every new Person IDby izaychik63 on 2020-12-22forum.knime.com/p/111797
- How to group data with 2 conditionsby armingrudd on 2019-08-22forum.knime.com/p/68503
- OFFSET IN Knimeby armingrudd on 2019-09-25forum.knime.com/p/71050
- Show all 14 links
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.