Rank but restarting after breaks

Hi @Bleck , this thread from 2022 shows one way of achieving this using a group loop and the Moving Aggregation node

If you have access to the KNIME hub, though, I have a component called “Cumulative Count for Grouping” that can simplify this for you, and uses an alternative method based on Java Snippet.

If you add this component to your workflow, and configure it so that the grouping column is your “work” column, it should give you the result you want. NB you may find you have to execute the component once after attaching it to the previous node before configuring it, so that it can detect the available columns. This is just a quirk of some components.

4 Likes