it sounds pretty easy but I don’t know how to do it in Knime without using a Python node. I want to add a column which is a running number from 1 to infinity with respect to a group. For example when I have the table:
It should add the following column
the Rank node does the job.
Hi @ArminFan , this can easily be done with the Rank node.
Here’s a sample workflow I put together:
Input data (same as yours):
Here’s the workflow:
Add index column with respect to group.knwf (9.6 KB)
Thanks for your answer. Did not know that such a node existed, but that’s the easy solution I was looking for.
No problem @ArminFan . You can play around with the Rank node and see the different results it gives, which might be helpful in the future.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.