transformations:removeemptycolumns
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
transformations:removeemptycolumns [2019/09/08 18:52] – dmitry | transformations:removeemptycolumns [2022/11/12 12:48] (current) – [Action settings] dmitry | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Remove empty columns | + | {{ transformations: |
+ | ====== | ||
+ | Category: Transform / Advanced\\ | ||
+ | \\ | ||
+ | =====Description===== | ||
This action removes columns with little or no meaningful information. It has three modes: | This action removes columns with little or no meaningful information. It has three modes: | ||
+ | *Remove columns where all values are empty values | ||
+ | *Remove columns where all values are empty or whitespace | ||
+ | *Remove columns where all values are the same | ||
- | | + | \\ |
+ | =====Use cases===== | ||
+ | | ||
+ | | ||
- | * **Remove | + | \\ |
+ | =====Action settings===== | ||
+ | ^Setting^Description^ | ||
+ | |All values are empty values|Removes | ||
+ | |All values are empty or whitespace|Removes | ||
+ | |All values are the same|Removes columns where all values are the same (e.g. when a column contains only text value " | ||
- | * **Remove columns where all values are the same** - removes columns where all values are the same, e.g. when a column contains only text value " | + | \\ |
- | The action can be helpful, for instance, after importing spreadsheets with sparsely located tables, or where table position changes from a file to file. It can also be used to remove columns that only contain null replacement values, such as " | + | =====Remarks===== |
+ | If the dataset has columns but no data (i.e. no rows), the action does nothing. | ||
- | **Example** | + | \\ |
+ | =====Examples===== | ||
- | Source dataset: | + | **Example: |
- | ^ Column 1 ^ Product name ^ Column 2 ^ Qty ^ Column 3 ^ Price ^ | + | |
+ | **Source dataset:** | ||
+ | ^ Column 1 ^ Product name ^ Column 2 ^ Qty ^ Column 3 ^ Price ^ | ||
| | Big thing | | 1| | 1000| | | | Big thing | | 1| | 1000| | ||
| | Medium thing | | 10| | 100| | | | Medium thing | | 10| | 100| | ||
| | Small thing | | 100| | 10| | | | Small thing | | 100| | 10| | ||
+ | \\ | ||
+ | **Action parameters: | ||
+ | >All values are empty values. | ||
- | Objective: remove empty columns. | + | \\ |
- | + | **Result | |
- | Result: | + | |
^ Product name ^ Qty ^ Price ^ | ^ Product name ^ Qty ^ Price ^ | ||
| Big thing | | Big thing | ||
Line 27: | Line 48: | ||
| Small thing | | Small thing | ||
- | **See also** | + | \\ |
+ | ====Community examples==== | ||
+ | | ||
+ | | ||
+ | * [[https:// | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
* [[transformations: | * [[transformations: |
transformations/removeemptycolumns.txt · Last modified: 2022/11/12 12:48 by dmitry