Add an auto incrementing number loop generator for a column

[psycho]

I need to get id column(in red colour) if the unitID is duplicating adding 1 value to it and then 2 and then 3 and so on. Could somebody help me with this this?

KNIME HELP.xlsx (9.9 KB)

[takbb]

Hi @pshycho, I think you could probably use the RANK node to get a column containing a sequential count within groupings of unitID and then use a MATH FORMULA node to add this column to the unitID which would generate the id column that you need.

[psycho]

It worked.Thank you takbb

[takbb]

You are welcome @psycho. Glad it worked for you and thank you for marking the solution.