I have a data table where columns A and B (amongst other columns in the set) look like
A B
5 8
5 4
6 7
7 8
7 10
7 4
8 1.5
8 3
8 12
I want to filter the table so that I only have rows where the value of B is the lowest seen for that value of A. In other words my result for that set should be
A B
5 4
6 7
7 8
8 1.5
Is there a way to do this in KNIME? I can easily sort the table but that doesn't get me the lowest value.