Automating Column Selection based on Statistics node output?

[robertlamb]

Hi - apologies if this has been addressed elsewhere…

I have an input table for analysis with about 300 columns. Of these, about 250 are “junk” - more than 90% missing values.

I can tag these columns in the output from the Statistics node and convert to a variable and pass it to Column Select.

However, in the Flow of the Column Select I appear to be able only to select individual items from the list, not pass the whole list.

Is there a better way to achieve this?

Thanks!

Robert

[HansS]

Hi @robertlamb

Welcome to KNIME Forum.
Did you check the Missing Value Column Filter.
gr. Hans

[robertlamb]

Brilliant!

Thanks Hans!