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