Filter blank rows out

[armingrudd]

Hi,

In addition to the solution by @izaychik63, you may prefer to transform the blank cells to missing value and then handle them as usual.

replace empty cell with missing (?) globally in table

Hi Both, how about using the Column Auto Type Cast for this: You can define a Missing Value pattern in the dialog. If you do this, it will automatically transform all emptys to Missing Values (And as a nice Side Effect the columns are automatically converted to the best fitting type) https://hub.knime.com/knime/nodes/Column_Auto_Type_Cast*iQCmMxBEl2szprD5 Cheers, Iris

replace empty fields

You could use the toNull() function in the String Manipulation node to convert blanks to missing values, and then handle all missings at once with the Missing Value node.

Best,
Armin