transformations:removeemptycolumns
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
transformations:removeemptycolumns [2021/04/09 00:29] – craigt | transformations:removeemptycolumns [2022/11/12 12:48] (current) – [Action settings] dmitry | ||
---|---|---|---|
Line 22: | Line 22: | ||
|All values are the same|Removes columns where all values are the same (e.g. when a column contains only text value " | |All values are the same|Removes columns where all values are the same (e.g. when a column contains only text value " | ||
+ | \\ | ||
+ | |||
+ | =====Remarks===== | ||
+ | If the dataset has columns but no data (i.e. no rows), the action does nothing. | ||
\\ | \\ | ||
=====Examples===== | =====Examples===== | ||
- | **Objective:** Remove empty columns.\\ | + | **Example:** Remove empty columns.\\ |
**Source dataset:** | **Source dataset:** | ||
Line 33: | Line 37: | ||
| | Medium thing | | 10| | 100| | | | Medium thing | | 10| | 100| | ||
| | Small thing | | 100| | 10| | | | Small thing | | 100| | 10| | ||
+ | \\ | ||
**Action parameters: | **Action parameters: | ||
>All values are empty values. | >All values are empty values. | ||
- | **Result:** | + | \\ |
+ | **Result | ||
^ Product name ^ Qty ^ Price ^ | ^ Product name ^ Qty ^ Price ^ | ||
| Big thing | | Big thing | ||
| Medium thing | | | Medium thing | | ||
| Small thing | | Small thing | ||
+ | |||
+ | \\ | ||
+ | ====Community examples==== | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
\\ | \\ | ||
=====See also===== | =====See also===== | ||
* [[transformations: | * [[transformations: |
transformations/removeemptycolumns.txt · Last modified: 2022/11/12 12:48 by dmitry