Count values in Column

[Knimer17]

Hello dear Knime Community,

can anyone help me?

In my table I have a column like this:

Every value should be counted and the output table I want should be like this.

Many thanks for your answers.

BR
Knimer17

[SimonS]

Hi @Knimer17,

the simplest way to achieve this I can think of right now is:

1. Use a Group Loop Start to loop over the distinct number groups.
2. Use a Counter Generation node to add a column with an incremental counter
3. Use a String Manipulation node to concatenate both columns.
4. Use a Loop End to collect the results.

I hope this helps you. Let me know if you need further instructions.

Simon

[HansS]

Hi @knimert17

I was think of using the Rank node. rank_values_count.knwf (19.7 KB)

gr. Hans

[SimonS]

Seems to be even easier. Thanks, @HansS!