filter special value in columns

KNIME Analytics Platform
1

hi friends

how can i filter  columns whith special value in it?

for example: if any column have value 10 filter it

or have null value filter it

thanks

2

For the special case of missing values, there is a node for that (Missing Value is the name).  For other cases, it can be a bit more complicated, but usually I would unpivot the columns that you want to filter, do the filtering with a single row filter, and then pivot back.  This is a bit tricky to set up the first time, but should be the most attractive solution in the long run.