Row filter

KNIME Analytics Platform
#1

Hi all,

I have for example 4 records with this information:

                      **Column 1**            **Column 2**               **Column 3**             **Column 4**

Row 1 A B C D
Row 2 A B C D
Row 3 A B C D
Row 4 A B C D

What I want is that if the 4 rows are exactly the same, there is only 1 row left. So Knime needs to remove the other 3 rows.

Can someone help?

Thank you very much!

Jacco

#2

Hey Jacco,

you can use the Group By node for this task. Select all the columns in the dialog which should be taken into account for comparing values between the rows. The Group By node then groups all rows that contain the same values within the selected columns, so that only one row remains.

Cheers,

Julian