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 Predecessors
- GroupBy9 %
- Sorter7 %
Row Filter (deprecated)6 %- Rule-based Row Filter5 %
- Math Formula4 %
- Joiner4 %
- Column Filter4 %
- Rank3 %
- Counter Generation2 %
- Concatenate2 %
- Rule Engine2 %
- Duplicate Row Filter2 %
- Column Expressions2 %
Column Rename2 %- String Manipulation2 %
- String to Date&Time2 %
- Excel Reader2 %
- Group Loop Start2 %
- Statistics1 %
Row Splitter (deprecated)1 %- Rule-based Row Splitter1 %
- Column Resorter1 %
- Missing Value< 1 %
- Constant Value Column< 1 %
- String to Number< 1 %
- DB Reader< 1 %
- Table Creator< 1 %
- Unpivot< 1 %
- Pivot< 1 %
- Table Manipulator< 1 %
Database Looping< 1 %- One Row to Many< 1 %
- R Snippet< 1 %
- CSV Reader< 1 %
Concatenate (Optional in)< 1 %- RowID< 1 %
- Math Formula (Multi Column)< 1 %
- Column Aggregator< 1 %
Python Script (1⇒1)< 1 %- Number Rounder< 1 %
- Column Renamer< 1 %
- Date&Time-based Row Filter< 1 %
- Cell Splitter< 1 %
- Nominal Value Row Filter< 1 %
- Value Counter< 1 %
- Cross Joiner< 1 %
- Java Snippet< 1 %
- Category to Number< 1 %
- Reference Row Filter< 1 %
Excel Reader (XLS)< 1 %- Date&Time Difference< 1 %
- Random Forest Predictor (Regression)< 1 %
- Date&Time Part Extractor< 1 %
File Reader< 1 %Loop End< 1 %Number To String< 1 %- Logistic Regression Predictor< 1 %
- Column Combiner< 1 %
- Moving Aggregator< 1 %
- Number to String< 1 %
- String Similarity< 1 %
- Table Row to Variable< 1 %
- Extract Table Spec< 1 %
Scorer< 1 %- Add Empty Rows< 1 %
Recursive Loop Start< 1 %- Numeric Row Splitter< 1 %
- TF< 1 %
- Extract Time Window (legacy)< 1 %
- Empty Table Switch< 1 %
- Loop End< 1 %
- Legacy Date&Time to Date&Time< 1 %
Extract Date&Time Fields< 1 %- Fingerprint Similarity< 1 %
- Data Explorer< 1 %
- List Files/Folders< 1 %
Cell Replacer< 1 %- Column Renamer (Dictionary)< 1 %
- Reference Row Splitter< 1 %
- Ungroup< 1 %
- Color Manager< 1 %
- Java Snippet (simple)< 1 %
- Date&Time to String< 1 %
- Fingerprint Similarity< 1 %
- Polynomial Regression Learner< 1 %
- Random Forest Predictor< 1 %
- Top k Row Filter< 1 %
- DB Query Reader< 1 %
- Column Filter (legacy)< 1 %
- Python Script (legacy)< 1 %
- Heatmap (JavaScript)< 1 %
- Table Writer< 1 %
- Cell Splitter By Position< 1 %
- Normalizer< 1 %
Rank Correlation< 1 %- End IF< 1 %
- SDF Reader< 1 %
- Create Date&Time Range< 1 %
- Speedy SMILES Heavy Atom Count (HAC)< 1 %
- Fingerprint INTERSECTS< 1 %
- Chunk Loop Start< 1 %
Excel Reader (XLS)< 1 %- Equal Size Sampling< 1 %
- String Manipulation (Variable)< 1 %
- Row Aggregator< 1 %
Database Connection Table Reader< 1 %- Distance Matrix Pair Extractor< 1 %
Cell Splitter< 1 %- Lag Column< 1 %
Linear Correlation< 1 %- Double to Integer< 1 %
- Missing Value Column Filter< 1 %
- Partitioning< 1 %
XLS Reader< 1 %- Topic Extractor (Parallel LDA)< 1 %
- Date Field Extractor (legacy)< 1 %
- String to Date/Time (legacy)< 1 %
Table Column to Variable< 1 %- Empty Table Creator< 1 %
- Line Plot (JavaScript)< 1 %
- File Reader< 1 %
- String Manipulation (Multi Column)< 1 %
- Math Formula (Variable)< 1 %
- Files/Folders Meta Info< 1 %
- Nominal Row Filter Configuration< 1 %
- Variable to Table Column< 1 %
- Column Selection Configuration< 1 %
- Create Collection Column< 1 %
CSV Reader< 1 %Database Reader< 1 %List Files< 1 %- Column List Loop Start< 1 %
- k-Means< 1 %
- Auto-Binner< 1 %
- Numeric Binner< 1 %
- Column Auto Type Cast< 1 %
Column Appender< 1 %- Column Rename (Regex)< 1 %
- Domain Calculator< 1 %
Joiner< 1 %- String Splitter (Regex)< 1 %
- Row Sampling< 1 %
- Column Splitter< 1 %
- String Replacer< 1 %
- Table Transposer< 1 %
- IF Switch< 1 %
- Random Number Assigner< 1 %
- Item Set Finder (Borgelt)< 1 %
- Table View (JavaScript)< 1 %
- Modify Time< 1 %
- Regression Predictor< 1 %
- Gradient Boosted Trees Predictor (Regression)< 1 %
- Column Merger< 1 %
- Constant Value Column Filter< 1 %
- Nominal Value Row Splitter< 1 %
- Row Filter (Labs)< 1 %
- Rank Correlation< 1 %
- Extract Table Dimension< 1 %
- Value Filter (legacy)< 1 %
- Table Editor (JavaScript)< 1 %
- Date&Time Shift< 1 %
- RDKit Descriptor Calculation< 1 %
- Table Reader< 1 %
- Table Row to Variable Loop Start< 1 %
- Column Appender< 1 %
- Linear Correlation< 1 %
- Fingerprint Similarity< 1 %
- Association Rule Learner< 1 %
- Collection to String< 1 %
- Value Lookup< 1 %
- Interactive Table (legacy)< 1 %
- Parquet Reader< 1 %
- JSON Path< 1 %
- Hierarchical Cluster Assigner (local)< 1 %
- Cache< 1 %
Python Script (1⇒2)< 1 %- Date&Time to legacy Date&Time< 1 %
- X-Aggregator< 1 %
- PCA< 1 %
- One-way ANOVA< 1 %
- ROC Curve (legacy)< 1 %
Read Excel Sheet Names (XLS)< 1 %- Recursive Loop Start< 1 %
- Missing Value (Apply)< 1 %
Regression Predictor< 1 %- Case Converter< 1 %
- Subset Matcher< 1 %
- Box Plot (legacy)< 1 %
- Association Rule Learner (Borgelt)< 1 %
Excel Sheet Appender (XLS)< 1 %- Java Snippet Row Splitter< 1 %
- Table to JSON< 1 %
- Modify Date< 1 %
- RDKit Canon SMILES< 1 %
- Information Gain Calculator< 1 %
Table Column to Variable< 1 %Counting Loop Start< 1 %Generic Loop Start< 1 %PCA< 1 %- Column Name Extractor< 1 %
- k-Medoids< 1 %
- Prediction Fusion< 1 %
- Integer Configuration< 1 %
Column Selection Configuration< 1 %Flow Variable IF Switch< 1 %- Java Edit Variable< 1 %
- Linear Regression Learner< 1 %
Random Forest Predictor< 1 %- Create Bit Vector< 1 %
String To Number< 1 %- Many to One< 1 %
- Filter Apply< 1 %
- Denormalizer< 1 %
CASE Switch Variable (Start)< 1 %- Parallel Chunk Start< 1 %
- Gaussian Distributed Assigner< 1 %
- Similarity Search< 1 %
- Keygraph Keyword Extractor< 1 %
- Google Sheets Reader< 1 %
- RDKit Optimize Geometry< 1 %
- RDKit To Molecule< 1 %
- SDF Reader< 1 %
Table Row to Variable< 1 %- ARFF Reader< 1 %
- Loop End (Column Append)< 1 %
Recursive Loop End< 1 %- Random Forest Learner (Regression)< 1 %
- One to Many< 1 %
- Reference Column Filter< 1 %
- Filter Apply Row Splitter< 1 %
- Decision Tree to Ruleset< 1 %
CASE Switch Data (End)< 1 %- Term Document Entropy< 1 %
- String Matcher< 1 %
- Dictionary Tagger< 1 %
- Stanford Tagger< 1 %
- Document Data Extractor< 1 %
- Quantile Filter< 1 %
- Feature Calculator (BETA)< 1 %
- Scorer< 1 %
Color Appender< 1 %- Random Number Assigner (Apache)< 1 %
- Excel Writer< 1 %
- Value Selection Configuration< 1 %
- Random Numbers Generator< 1 %
- Desirability Ranking< 1 %
- String to URI< 1 %
- URI to String< 1 %
- URL to File Path< 1 %
Variable to Table Row< 1 %Parameterized Database Query< 1 %Table Reader< 1 %Naive Bayes Predictor< 1 %- PNN Predictor< 1 %
- Cluster Assigner< 1 %
- Decision Tree Predictor< 1 %
Tree Ensemble Predictor (Regression)< 1 %Gradient Boosted Trees Predictor< 1 %Tree Ensemble Predictor< 1 %- Simple Regression Tree Predictor< 1 %
- Low Variance Filter< 1 %
CASE Switch Data (Start)< 1 %- Data Generator< 1 %
Excel Reader (XLS)< 1 %- Java Edit Variable (simple)< 1 %
- NGram Creator< 1 %
- Term to String< 1 %
- JPMML Classifier< 1 %
- Time Difference (legacy)< 1 %
- Time Generator (legacy)< 1 %
- Mask Date/Time (legacy)< 1 %
- Speedy SMILES Ring Count< 1 %
- Entropy Uncertainty Scorer< 1 %
- Split Collection Column< 1 %
- File Meta Info (legacy)< 1 %
Table Row to Variable< 1 %- Feature Selection Filter< 1 %
- Feature Selection Loop Start (1:1)< 1 %
- K Nearest Neighbor< 1 %
- MDS< 1 %
PCA Apply< 1 %- Numeric Scorer< 1 %
- PCA Apply< 1 %
- Tree Ensemble Predictor (Regression)< 1 %
- Random Forest Learner< 1 %
- Binner (Dictionary)< 1 %
- Bootstrap Sampling< 1 %
Double To Int< 1 %- Normalizer (Apply)< 1 %
- String to Number (PMML)< 1 %
- Reference Column Resorter< 1 %
- Shuffle< 1 %
- Rule Engine (Dictionary)< 1 %
- Numeric Outliers< 1 %
Merge Variables< 1 %- Timer Info< 1 %
- HiLite Table (legacy)< 1 %
- Save Workflow< 1 %
- Molecule Type Cast< 1 %
- Random Label Assigner< 1 %
- Distance Matrix Calculate< 1 %
- H2O MOJO Predictor (Classification)< 1 %
- H2O to Table< 1 %
- H2O Gradient Boosting Machine Learner< 1 %
- H2O Generalized Linear Model Learner< 1 %
- DF< 1 %
- String to Term< 1 %
- Weka Cluster Assigner (3.7)< 1 %
- Column Selection (legacy)< 1 %
- ROC Curve (JavaScript)< 1 %
- String Widget< 1 %
- JSON to Table< 1 %
- Don't Save End< 1 %
Python Script (2⇒1)< 1 %- Python Source (legacy)< 1 %
- R Source (Table)< 1 %
- Duration to Number< 1 %
- Time Field Extractor (legacy)< 1 %
- Moving Average< 1 %
- Time to String (legacy)< 1 %
- Byte Converter< 1 %
- XSLT< 1 %
- RDKit RMSD Filter< 1 %
Column Distance< 1 %- Molecule Properties< 1 %
- MMP Molecule Fragment (RDKit)< 1 %
- Inject Column Properties< 1 %
- Pareto Ranking< 1 %
- Breakpoint< 1 %
- Inject Variables (Data)< 1 %
- Variable Condition Loop End< 1 %
- Logistic Regression Learner< 1 %
- Tree Ensemble Predictor< 1 %
- Column Comparator< 1 %
- Column to Grid< 1 %
- Edit Nominal Domain< 1 %
- HiLite Row Splitter< 1 %
- Row Splitter (Labs)< 1 %
- Number to String (PMML)< 1 %
- Merge Variables< 1 %
- Conditional Label Assigner< 1 %
- Read Excel Sheet Names< 1 %
- Chi-Square Keyword Extractor< 1 %
- Unique Term Extractor< 1 %
- Interactive Range Slider Filter Widget< 1 %
- Webpage Retriever< 1 %
- XGBoost Predictor (Regression)< 1 %
- XPath< 1 %
- 3D D-Similarity< 1 %
- RDKit Molecule Substructure Filter< 1 %
Regex Extractor< 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 450 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.