User Tools

Site Tools


transformations:removeemptyrows

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

transformations:removeemptyrows [2019/09/08 22:52] (current)
dmitry created
Line 1: Line 1:
 +===== 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:​removeemptycolumns|Remove empty columns]]
transformations/removeemptyrows.txt · Last modified: 2019/09/08 22:52 by dmitry