DB Row Filter - Addressing Missing Values

KNIME Analytics Platform
1

Hi there

I am using the DB Row Filter and wanted to filter out the ‘false’ in column 1. However, there is a single missing value, which limits the DB Row Filter node to only offer the IS NULL or IS NOT NULL condition.

Data Sample:
image

DB Row Filter Options for Column1:
image

I tried to remove the missing value in a previous node however the DB Row Filter continues to only offer the two filtering options above.

Is there an alternative to fixing this inside the DB Row Filter, to avoid having to write a DB Query?

Thanks!

2

Hi there @supersharp,

currently not (it is not related to missing values in your row). It was already reported here and there is ticket to add support for Boolean equals and not equals operators. Will add +1 for you.

Br,
Ivan

1 Like