User Tools

Site Tools


transformations:removeemptyrows

Remove empty rows

Category: Transform / Advanced.

This action removes empty rows, or rows that don't look empty and don't have any meaningful information (e.g. whitespace values). For convenience, certain columns can be ignored if they have non-empty values which are not necessary.

Example

Source dataset:

Product name Qty Price Note
Big thing 1 1000
No data here
Medium thing 10 100
Small thing 100 10

Objective: remove empty rows, ignore column [Note].

Result:

Product name Qty Price Note
Big thing 1 1000
Medium thing 10 100
Small thing 100 10

Use cases

The action can be convenient for removing empty rows without using a filter. When empty rows are removed using a filter applied to 1 or several columns there is always a risk that important data may reside in columns not included in the filters and thus accidentally removed. The “Remove empty rows” action reduces this risk and guarantees that only rows without meaningful information will be removed.

See also

transformations/removeemptyrows.txt · Last modified: 2019/09/08 22:52 by dmitry