Rank

Options

Ranking Attributes

Ranking attributes can be added, removed and prioritized by the corresponding buttons. In order to change the selected attribute one can click on the name of a attribute to open a drop-down menu with all available attributes. The same applies for the ranking order, the options

The first attribute in the ranking table has the highest priority for ranking, all following attributes only come into play when there are ties in the attributes higher up in the table.

An attribute can be chosen by clicking on one of the attribute names in the table and selecting the desired attribute in the drop down menu.

For each attribute one can choose whether the ranking should be computed ascending or descending. To do so, click on the order for the corresponding ranking attribute and select the desired value.

Grouping Attributes

Ranking attributes can be added and removed by the corresponding buttons.

An attribute can be chosen by clicking on an attribute name and selecting the desired attribute in the drop down menu.

Ranking Mode

There are three possible ranking modes:

• Standard: Rows with the same values in the ranking attributes receive the same rank and the next row with a different value receives a rank that is increased by the number of rows that had the same rank. Therefore the ranking has gaps.
• Dense: Rows with the same values in the ranking attributes receive the same rank but the row with the next different value receives a rank that is only incremented by one.
• Ordinal: The ranking is consecutive, even rows with the same values in the ranking attributes receive unique ranks.

Name of Rank Attribute

The name that the appended ranking column should have. An empty name is not permitted.

Retain Row Order

If checked, the original row order is retained. This option should only be checked if really necessary because the restoration of the row order is runtime intensive.

Rank as Long

Check this option if the appended rank attribute should be of type Long. It is recommended to use this option only if the input table is very large. Otherwise the type int will be sufficient to capture all ranks.

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 357 workflows

Links

• How can I generate sequence numbers?by izaychik63 on 2019-06-18

  forum.knime.com/p/62424
• row counter over partitionsby HansS on 2021-08-12

  forum.knime.com/p/131705
• Incremental count restarting every new Person IDby izaychik63 on 2020-12-22

  forum.knime.com/p/111797
• How to group data with 2 conditionsby armingrudd on 2019-08-22

  forum.knime.com/p/68503
• OFFSET IN Knimeby armingrudd on 2019-09-25

  forum.knime.com/p/71050
• number the column values by categoriesby ipazin on 2023-03-29

  forum.knime.com/p/198888
• column where the data may be the same in several rows. For each occurance I would like to append a suffix.by izaychik63 on 2021-01-31

  forum.knime.com/p/114688
• Knime Value Counter for groupsby HansS on 2019-07-23

  forum.knime.com/p/66141
• Data Transformation Queryby armingrudd on 2019-10-14

  forum.knime.com/p/72262
• How to allocate case idby HansS on 2019-09-20

  forum.knime.com/p/70500
• How to count from first unique value till the next unique value is encountered?by izaychik63 on 2019-07-15

  forum.knime.com/p/65515
• Counter Restart when row value changeby gonhaddock on 2022-04-25

  forum.knime.com/p/154836
• Split duplicate lines by 1st,2nd 3rd etc..by izaychik63 on 2020-11-16

  forum.knime.com/p/108317
• Incremental Counter Based on Date and Time Stamp - Row Subsetby HansS on 2022-06-02

  forum.knime.com/p/159032

Developers