Delete Row with zero strings

KNIME Analytics Platform
1

Hallo,

 

I´m new here in Knime. I want do delete rows with a "Zero" String. The Missing Value node doesn´t work. What can I do else?

 

Thanks a lot

2

The easiest would be to use the Column Aggregator node to concatenate all content in the rows (maybe you can also specify a character that is not present in "Zero"), and use some of the row filtering nodes on that column. Finally, you should remove the generated column.

(If you have only a few columns, the Rule-based Row Filter/Splitter might be an easier option.)

Cheers, gabor

3

Hey JaySmeyr,

For a single column use the row filter and include all rows that match the regex ".+", than empty strings are sorted out. If you want to do that for all columns try looping over the columns with this technique.

Best,
Ferry