For each group an individual ranking is computed based on the selected ranking attribute(s) and ranking mode. The user must provide at least one attribute on which a ranking should be calculated.
The groups are determined by the unique value combinations of the grouping attribute(s). If no grouping attribute is provided, one ranking will be calculated for the whole table.
Missing values are considered to represent the largest value possible.
The columns in the input table will be called "attributes" to avoid confusion with the table structures in the dialog.
Options
Popular Successors
Row Filter (deprecated)13 %- Rule-based Row Filter10 %
- Joiner8 %
- Math Formula5 %
- GroupBy4 %
- Sorter4 %
- Rule Engine4 %
- Column Filter3 %
- Excel Writer3 %
- Rank3 %
- Column Resorter2 %
- String Manipulation2 %
- Pivot2 %
- Column Expressions2 %
Column Rename2 %- Loop End1 %
Row Splitter (deprecated)1 %- Concatenate1 %
- Duplicate Row Filter1 %
- Rule-based Row Splitter< 1 %
Rank Correlation< 1 %- Lag Column< 1 %
- CSV Writer< 1 %
Joiner< 1 %- Number to String< 1 %
- Line Plot (legacy)< 1 %
- Column Combiner< 1 %
String To Number< 1 %- Missing Value< 1 %
- Constant Value Column< 1 %
- Reference Row Filter< 1 %
- Bar Chart (JavaScript)< 1 %
- Group Loop Start< 1 %
- Table Row to Variable Loop Start< 1 %
- Cross Joiner< 1 %
- R Snippet< 1 %
Concatenate (Optional in)< 1 %- Value Counter< 1 %
- Bar Chart< 1 %
- Java Snippet (simple)< 1 %
- Numeric Row Splitter< 1 %
- Top k Row Filter< 1 %
Table Writer< 1 %- String to Number< 1 %
- RowID< 1 %
- Table View (JavaScript)< 1 %
- Date&Time Shift< 1 %
- Chunk Loop Start< 1 %
- Nominal Value Row Filter< 1 %
- Row Filter (Labs)< 1 %
Excel Sheet Appender (XLS)< 1 %Table Row to Variable< 1 %Column Appender< 1 %- Filter Apply< 1 %
- Table Transposer< 1 %
- Interactive Table (legacy)< 1 %
- Add Empty Rows< 1 %
- Column Comparator< 1 %
Linear Correlation< 1 %- Line Chart (JFreeChart)< 1 %
- R View (Table)< 1 %
- Date&Time Part Extractor< 1 %
- Date&Time-based Row Filter< 1 %
- Auto-Binner< 1 %
- Column Renamer< 1 %
- Table Manipulator< 1 %
- Partitioning< 1 %
- IF Switch< 1 %
- Molecule Type Cast< 1 %
- Counter Generation< 1 %
Excel Sheet Appender (XLS)< 1 %- Table Row to Variable< 1 %
- Table Writer< 1 %
- Loop End (Column Append)< 1 %
Recursive Loop Start (2 ports)< 1 %- Numeric Binner< 1 %
- Cell Splitter< 1 %
- Column Auto Type Cast< 1 %
- Linear Correlation< 1 %
- Reference Column Resorter< 1 %
- Lift Chart (legacy)< 1 %
- Statistics View< 1 %
Excel Writer (XLS)< 1 %- Tableau Writer< 1 %
- Line Plot (JavaScript)< 1 %
- JChem Update< 1 %
- Variable to Table Column< 1 %
Loop End< 1 %Counting Loop Start< 1 %Recursive Loop Start< 1 %- Column Rename (Regex)< 1 %
- Double to Integer< 1 %
- Nominal Value Row Splitter< 1 %
- Subset Matcher< 1 %
- Normalizer< 1 %
- Rank Correlation< 1 %
- Numeric Outliers< 1 %
- End IF< 1 %
- Scatter Plot (legacy)< 1 %
- Pie Chart< 1 %
- Table View< 1 %
- Scatter Plot (Plotly)< 1 %
- Math Formula (Multi Column)< 1 %
Excel Writer (XLS)< 1 %- Scatter Plot (JavaScript)< 1 %
- Date&Time to String< 1 %
- Modify Time< 1 %
- Moving Aggregator< 1 %
- String Similarity< 1 %
- Range Filter< 1 %
Table Column 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 %
- Column List Loop Start< 1 %
- Recursive Loop Start< 1 %
Naive Bayes Learner< 1 %- k-Means< 1 %
- Linear Regression Learner< 1 %
Scorer< 1 %- Numeric Scorer< 1 %
- Bootstrap Sampling< 1 %
Cell Replacer< 1 %- Category to Number< 1 %
- Column Aggregator< 1 %
- Column Appender< 1 %
- Column Renamer (Dictionary)< 1 %
- Equal Size Sampling< 1 %
- Number to String (PMML)< 1 %
- Number Rounder< 1 %
- Row Sampling< 1 %
- Shuffle< 1 %
- Column Splitter< 1 %
- String Manipulation (Multi Column)< 1 %
- Table Cropper< 1 %
- Table Difference Finder< 1 %
- Ungroup< 1 %
- Unpivot< 1 %
- Value Lookup< 1 %
- Rule Engine (Dictionary)< 1 %
- Statistics< 1 %
- Extract Table Dimension< 1 %
- Crosstab< 1 %
- Color Manager< 1 %
- Scatter Plot< 1 %
- DB Writer< 1 %
- DB Table Creator< 1 %
- One Row to Many< 1 %
- Pie/Donut Chart (JavaScript)< 1 %
- Math Formula (Variable)< 1 %
- Histogram Chart (JFreeChart)< 1 %
- Scatter Plot (JFreeChart)< 1 %
Send to Tableau Server (Hyper)< 1 %- Heatmap (JavaScript)< 1 %
- Value Selection Widget< 1 %
- Python Script (legacy)< 1 %
- Data to Report (BIRT)< 1 %
- Date&Time Difference< 1 %
- String to Date&Time< 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 %
- DB Insert< 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)< 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 %
- Sunburst Chart (JavaScript)< 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)< 1 %
- Tile View (JavaScript)< 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 %
- Histogram (JavaScript)< 1 %
- Table to PMML Ensemble< 1 %
XLS Writer< 1 %Send to Power BI< 1 %- Send to Power BI< 1 %
TIBCO File Writer< 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)< 1 %
- Tag Cloud (JavaScript)< 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 %
- Legacy Date&Time to Date&Time< 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 449 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.