Group similar (identical ) rows of Table

[malik]

Hello
How one can group similar or identical rows of table?

Malik

[mlauber71]

You could use the group by node:

https://www.knime.com/nodeguide/etl-data-manipulation/aggregations/basic-examples-for-using-the-groupby-node

Or you could use an artificial ID like in this example:

Compare data on two rows

I attached a workflow that does what you want. Please do not blame overworked nurses, appreciate their work, hire more of them and give them a raise! [image] I use the three columns that should match to create an artificial ID, I sort by that id and the Time Called and then use a rule to define what is a match [image] kn_example_nurses_call.knwf (60.0 KB)

Or you might describe what you want to do in greater detail, maybe even have an example or some data.