Solved: [Adding Rank Value Column]

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? 



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)"



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.



Hi J,

the most simple way is the counter node.

Cheers, Iris

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