transformations:removeemptycolumns
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revisionNext revisionBoth sides next revision | ||
transformations:removeemptycolumns [2018/07/22 16:27] – created dmitry | transformations:removeemptycolumns [2021/04/09 00:29] – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Remove empty columns | + | {{ transformations: |
+ | ====== | ||
+ | Category: Transform / Advanced\\ | ||
- | This action removes columns with no meaningful information | + | \\ |
+ | =====Description===== | ||
+ | This action removes columns with little or no meaningful information. It has three modes: | ||
+ | *Remove columns where all values are empty values | ||
+ | *Remove | ||
+ | *Remove | ||
- | 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 " | + | \\ |
+ | =====Use cases===== | ||
+ | *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 " | ||
- | **Example** | + | \\ |
+ | =====Action settings===== | ||
+ | ^Setting^Description^ | ||
+ | |All values are empty values|Removes columns that only contain empty values (nulls)| | ||
+ | |All values are empty or whitespace|Removes columns that contain either empty or whitespace values (e.g. values with only spaces, line breaks, or tabs but no visible characters).| | ||
+ | |All values are the same|Removes columns where all values are the same (e.g. when a column contains only text value " | ||
- | Source dataset: | + | |
- | ^ Column 1 ^ Product name ^ Column 2 ^ Qty ^ Column 3 ^ Price ^ | + | \\ |
+ | =====Examples===== | ||
+ | |||
+ | **Objective: | ||
+ | |||
+ | **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| | ||
- | Objective: remove | + | **Action parameters:** |
+ | >All values are empty values. | ||
- | Result: | + | **Result:** |
^ Product name ^ Qty ^ Price ^ | ^ Product name ^ Qty ^ Price ^ | ||
| Big thing | | Big thing | ||
Line 21: | Line 43: | ||
| Small thing | | Small thing | ||
+ | \\ | ||
+ | =====See also===== | ||
+ | * [[transformations: |
transformations/removeemptycolumns.txt · Last modified: 2022/11/12 12:48 by dmitry