Delete column with one specific value

KNIME Analytics Platform
1

Hi there,

I would like to delete a column if it contains the value "-". If there is another value in this column which is not "-" it should not be deleted.

Is there a node to solve this? 

Thanks in advance,

Simon

2

Hi Simon,

you can delete the value "-" in your column with the String Manipulation Node:

toNull(removeChars($Your_column$, "-"))

Then you can use the Missing Value Column Filter, setting the Missing value threshold to 100%.

3

Hi Agaunt,

thanks for your help.