Add an auto incrementing number loop generator for a column

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?

image

KNIME HELP.xlsx (9.9 KB)

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.

3 Likes

It worked.Thank you takbb :star_struck:

1 Like

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

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.