add a suffix number at the end of the values

[psycho]

I have below table and i want to generate the last column which is in red.

Data set -
KNIME HELP.xlsx (10.0 KB)

Could somebody help me to resolve this please?

thanks in advance

[HansS]

Hi @psycho

I think their are multiple ways to answer this question with KNIME. But this an option
add_counter.knwf (35.4 KB)

[ScottF]

Hi @psycho -

Am I mistaken, or isn’t this question very similar to one you posed previously? Can that solution be adapted to this one?

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)

[psycho]

Thank you very much HanaS. This is what I have been looking for.

[psycho]

I am new to this forum still I am learning. I am grateful if you could help me to use this solution to adopt with the above issue I have posted today. Then I can learn two different methods.

[rfeigel]

Here’s another approach.

Add Column Number – rfeigel