How can i eliminate all the missing value from a data set?

It worked for me. Thank you!

A simple way to do this is using an R-Snippet with the code

knime.out<-knime.in(complete.cases(knime.in),]

1 Like

A way to do this without regex is to use the Column Auto Type Cast node:
Column Auto Type Cast — NodePit

and set the “missing value pattern” to “empty”:

image

This should then give you missing values in your empty cells that can be filtered or manipulated otherwise:

image

BW