0 ×

Remove Empty Rows

StreamableGeneric Nodes - Node extension for KNIME Workbench provided by Lhasa Limited version 1.2.100.v202007031132 by Lhasa Limited

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

Icon
A table that may contain rows with only missing cells

Output Ports

Icon
The input table with the missing rows removed

Best Friends (Incoming)

Best Friends (Outgoing)

Workflows

Installation

To use this node in KNIME, install Lhasa public plugin from the following update site:

KNIME 4.3

A zipped version of the software site can be downloaded here.

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.

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.