Remove Empty Rows

This node removes empty rows from the input table. An empty row can be defined as: a row that has only missing cells or a row that has no columns. For the second definition all rows would therefore be empty in a given input table.

The node can be configured to handle either of the definitions of missing or both.

For example if you have a scenario where you have RowIds but no columns if you want to return a completely empty table then ensure the 'Remove row where no columns are present' is selected. If you only wont to manipulate the table when no columns are present (for example when working through a loop giving different input) then ensure 'Remove row where no columns are present' is checked and 'Remove entirely Missing Cell rows' is not checked. If both are selected you will also lose rows that consist of only missing cells.

Example Input:

RowID	Col1	Col2
Row1	A	B
Row2		C
Row3

Output when 'Remove entirely Missing Cell rows' is enabled:

RowID	Col1	Col2
Row1	A	B
Row2		C

If unchecked no change will be seen.

Second example input:

RowID
Row1
Row2
Row3

Expected output if 'Remove row where no columns are present' is checked (a completely empty table):

RowID

If unchecked the table will remain unchanged.

Options

Remove entirely Missing Cell rows: Rows that only contain missing cells are removed
Remove row where no columns are present: Rows that have no columns are removed. For example if the input table has RowIDs but no columns if this option is enabled an completely empty table will be output.

Input Ports

: A table that may contain rows with only missing cells

Output Ports

: The input table with the missing rows removed

Popular Predecessors

Column Rename6 %
Column Expressions4 %
CSV Reader3 %
Excel Writer3 %
Column Splitter3 %
RowID3 %
Column Resorter3 %
String Replacer3 %
Cell Splitter3 %
GroupBy2 %
Missing Value Column Filter2 %
Missing Value2 %
String To Number2 %
Rule Engine2 %
Table Transposer2 %
Empty Table Switch2 %
Concatenate2 %
Column Filter2 %
Row Filter2 %
Duplicate Row Filter2 %
Missing Value (Apply)2 %
Sorter2 %
String Manipulation2 %
Joiner2 %
String Manipulation (Multi Column)2 %
Excel Reader2 %
File Reader2 %
Loop End2 %
Row to Column Header2 %
CSV Reader1 %
Excel Reader (XLS)1 %
Category To Number1 %
Table Editor1 %
File Chooser Widget1 %
String to Date&Time1 %
File Reader1 %
Table Creator1 %
Reference Column Filter1 %
Unpivoting1 %
Molecule Type Cast1 %
Cell Replacer1 %
Constant Value Column1 %
Rule-based Row Filter1 %
JSON Path1 %
RDKit Fingerprint1 %
Loop End (Column Append)< 1 %
Joiner< 1 %
Pivoting< 1 %
Numeric Outliers< 1 %
R Snippet< 1 %
Molecular Properties< 1 %
Table Manipulator< 1 %
Table Row to Variable< 1 %
Loop End< 1 %
Cell Splitter< 1 %
Cell Splitter By Position< 1 %
SDF Reader< 1 %
Remove Empty Rows< 1 %
RDKit Descriptor Calculation< 1 %
Tautomer Generator< 1 %
Column Auto Type Cast< 1 %
String To Number< 1 %
Column Merger< 1 %
Column Rename (Regex)< 1 %
Row Splitter< 1 %
Reference Row Filter< 1 %
Partitioning< 1 %
OpenBabel< 1 %
Excel Reader (XLS)< 1 %
N Chars Filter< 1 %
Test Data Generator< 1 %
RDKit Canon SMILES< 1 %
Table Reader< 1 %
Column Aggregator< 1 %
Statistics< 1 %
End IF< 1 %
Empty Table Creator< 1 %
Table View< 1 %
Date&Time to String< 1 %

Popular Successors

Rule-based Row Filter3 %
Cell Splitter3 %
Rule-based Row Splitter2 %
Joiner2 %
Component Output2 %
Show all 169 recommendations

Views

This node has no views

Workflows

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.

Installation

To use this node in KNIME, install the extension Lhasa public plugin from the below update site following our NodePit Product and Node Installation Guide:

v5.12

Plugin provider: Lhasa Limited

Plugin version: 2.2.1.v202511242342

On NodePit since: 2026-07-06

Last update: 2026-08-01

Tags: Streamable

KNIME versions: Since v3.6

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!