Solved: [Adding Rank Value Column]

KNIME Analytics Platform
1

Hi all,

I'm trying to accomplish a task that seems simple, but can't seem to find a solution for it.

I have created a table with the data sorted from "best to worse". I would like to add a numerical column, so that the first row gets value '1', second row value '2', etc.

What's the best way to do this? 

Thanks!

-J

2

If you connect a String Manipulation node up and use "string($$ROWINDEX$$)" in the Expression and append column you should get a new column that gives the index of the row. 

If you want it to start from 1 you should use "string($$ROWINDEX$$+ 1)"

Cheers

Sam

3

You can also use the Maths Formula node, with simply the ROWINDEX as the Maths Expression. Or ROWINDEX+1 if you want to start from 1 rather than 0.

 

Simon.

4

Hi J,

the most simple way is the counter node.

Cheers, Iris

5

Thanks a lot for the replies! As Iris mentioned, the counter node does the trick the easiest way.