Extracting unique value of a column and removing columns

[JaeHwanChoi]

Hello, KNIME Support Team.

I currently have data with 500 columns and 15000 ROWs.

I want to configure a WF to check the unique value of each column and remove it if it has 1 unique value.

1. due to the large number of columns, I can’t use the groupby node to check for unique values. I also can’t find the unique values in the statistic node.

Is there a node that can easily check the unique values for each column?

2. Once #1 is done, I would like to filter and remove only the columns with 1 unique value, how can I do that?

Any help would be greatly appreciated.

[HansS]

Hi @JaeHwanChoi

I think your are looking for the

Constant Value Column Filter

gr. Hans

[JaeHwanChoi]

Thanks @HansS . Just what I was looking for.