Icon

04_​Generating_​a_​Ranking_​value

How to use the Rank node to compute rankings

This workflow shows how the rank node in combination with a Row Filter node can be used to determine the rows whose ranking column attribute is in the top 5 values for this column.

This workflow is an example of a Rank Node being used together with a Row Filter Node.For more information see the workflow metadata. Find it here: View -> Description Creates a simple tableAttributes are age and genderPerforms ascendingranking on full table.Ranking column is Age.Uses dense rank modePerforms descending rankingfor males and females independently.using age as grouping column,age as ranking column and the dense rank modeKeeps rows witha rank lowerthan 6Keeps rows witha rank lower than 6(as we used a descendingranking this time, we will get therows with the 5 largest age values) Table Creator Rank Rank Row Filter Row Filter This workflow is an example of a Rank Node being used together with a Row Filter Node.For more information see the workflow metadata. Find it here: View -> Description Creates a simple tableAttributes are age and genderPerforms ascendingranking on full table.Ranking column is Age.Uses dense rank modePerforms descending rankingfor males and females independently.using age as grouping column,age as ranking column and the dense rank modeKeeps rows witha rank lowerthan 6Keeps rows witha rank lower than 6(as we used a descendingranking this time, we will get therows with the 5 largest age values) Table Creator Rank Rank Row Filter Row Filter

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Adrian Nembach
Created at: 2015-12-08
On NodePit since: 2019-07-12
Last update: 2024-04-18
Created with KNIME version: v4.1.1
Tags: ETLrankrow filterranking

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!