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:

RowIDCol1Col2Row1ABRow2CRow3

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

RowIDCol1Col2Row1ABRow2C

If unchecked no change will be seen.

Second example input:

RowIDRow1Row2Row3

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

RowID

If unchecked the table will remain unchanged.

Input ports

1. Type: Table
   Table with potentially missing rows
   A table that may contain rows with only missing cells

Output ports

1. Type: Table
   Missing rows removed
   The input table with the missing rows removed