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.
the most simple way is the counter node.
Thanks a lot for the replies! As Iris mentioned, the counter node does the trick the easiest way.