Differences

This shows you the differences between two versions of the page.

--- transformations:removeemptycolumns [2018/10/10 07:51] – dmitry
+++ transformations:removeemptycolumns [2021/04/09 00:29] – craigt
@@ Line 1: / Line 1: @@
-===== Remove empty columns =====
+{{ transformations:RemoveEmptyColumnsAction.png}}
+====== REMOVE EMPTY COLUMNS ======
+Category: Transform / Advanced\\
+\\
+=====Description=====
 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
-  * **Remove columns where all values are empty values** - removes columns that only contain empty values (nulls)
+\\
+=====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 "NULL".\\
-  * **Remove columns where 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)
+\\
+=====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 "N/A" in all rows).|
-  * **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 "N/A" in all rows.
-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 "NULL".
+\\
+=====Examples=====
-**Example**
+**Objective:** Remove empty columns.\\
-Source dataset:
+**Source dataset:**
-^ Column 1 ^ Product name ^ Column 2 ^ Qty ^ Column 3 ^ Price ^
+^ Column 1  ^ Product name  ^ Column 2  ^ Qty  ^ Column 3  ^ Price  ^
 | | Big thing     | |    1| |  1000|
 | | Medium thing  | |   10| |   100|
 | | Small thing   | |  100| |    10|
-Objective: remove empty columns.
+**Action parameters:**
+>All values are empty values.
-Result:
+**Result:**
 ^ Product name ^ Qty ^ Price ^
 | Big thing     |    1|  1000|
@@ Line 27: / Line 43: @@
 | Small thing   |  100|    10|
+\\
+=====See also=====
+  * [[transformations:removeemptyrows|Remove empty rows]]