Crear un Row Number en Knime

[hamapa05]

Hola a todos, una colaboracion… necesito crear un row numbes en Knime que me adicione una columna a una tabla con una serie de numeros dependiendo de otra columna … ejemplo.

saben como lo puedo lograr?

gracias de antemano.

[bruno29a]

Hi @hamapa05 , please provide input data in the future so we know what’s input and what’s output.

I am guessing that the input data is as follows?

Here’s a workflow I put together: Create Row Number based on another column.knwf (14.7 KB)

It produces this result:

[takbb]

I have borrowed @bruno29a’s idea, and included an alternative using the Rank node.

I think both solutions work and do the same job, as long as Col 1 is always repeating all of the values. It seems to work
Create Row Number based on another column - using Rank.knwf (18.2 KB)

Edit: I just realised that if you tick “Retain Row Order”, the Rank node does the entire job without having to join back…

[bruno29a]

Nice @takbb , I like this alternative

[hamapa05]

Excelente, voy a probarlo!

[hamapa05]

Muchas gracias, voy a probarlo.