transformations:removeemptyrows
no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
Next revision | |||
— | transformations:removeemptyrows [2019/09/08 18:52] – created dmitry | ||
---|---|---|---|
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, | ||
+ | |||
+ | **Example** | ||
+ | |||
+ | Source dataset: | ||
+ | ^ Product name ^ Qty ^ Price ^ Note ^ | ||
+ | | Big thing | ||
+ | | | ||
+ | | Medium thing | | ||
+ | | Small thing | ||
+ | |||
+ | Objective: remove empty rows, ignore column [Note]. | ||
+ | |||
+ | Result: | ||
+ | ^ Product name ^ Qty ^ Price ^ Note ^ | ||
+ | | Big thing | ||
+ | | Medium thing | | ||
+ | | Small thing | ||
+ | |||
+ | **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 " | ||
+ | |||
+ | **See also** | ||
+ | |||
+ | * [[transformations: |
transformations/removeemptyrows.txt · Last modified: 2021/07/19 02:20 by craigt