Exclude columns with dublicates

KNIME Analytics Platform
1

I got a set of columns, with an id and a number. What i am looking for is a way to exclude any id, which a number their acquire multiple times inside the same id. I have tried to illustarate it below,

 

Column

A 1

A 2

A 2

B 2

B 1

B 4

B  2

The result i am looking for:

A 1

B 1

B 4

 

2

Hi,

 

have you tried a groupBy Node? You can use as aggregate function "First".

 

Regards

3

Hello Xzull,

Use GroupBy and group on ID and number. As aggregation use count and then use a Row Filter to exclude everything that has a count greater than 1.

Best,
Ferry

4

Thanks :) worked!