Unique rows according to selected columns

KNIME Analytics Platform
#1

Hey community!

I have a question about filtering all unique rows from a table according to two selected columns, which should be unique.

example:

ID supplier product
1 X A
1 X B
2 Y A
2 Y A

result:

ID supplier product
1 X A
2 Y A

I wanna have all the unique ID and supplier rows.
So it does not matter what is written in column product but I still want to have any info there.

Thank you!
Antonius

#2

Use Group by node with grouping on the first 2 columns and use First as aggregation function for the third column.

3 Likes
#3

Thank you so much! :slight_smile: