Delete Row with zero strings



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

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

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.