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