Como reiniciar numeración dependiendo de otra columna

[aworker]

Hola @Gambito23 y bienvenido al forum de KNIME

Lo que quieres hacer, lo puedes implementar usando el nodo -Rank-:

Rank

Adjunto te envio un par de ejemplos de como usarlo:

How to use the Rank node to compute rankings – knime

Sorting a Column based on a repeating pattern?

Hi @tschmied Please find a possible solution below based on the -Rank- node: [image] [image] If I got it right, the workflow preserves the other rows info order as needed, for instance: Initial unsorted dummy example data: [image] The result: [image] As you can see on the highlighted ones, the order of ones is preserved given their initial Row Index (1, 6, 7, 11). 20210927 Pikairos Sorting a Column based on a repeating pattern.knwf (29.8 KB) Hope this helps. Best Ael

Espero que sean de ayuda.

Saludos
Ael