Differences

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

--- transformations:removeemptycolumns [2018/07/22 16:27] – created dmitry
+++ transformations:removeemptycolumns [2019/09/08 18:52] – dmitry
@@ Line 1: / Line 1: @@
 ===== Remove empty columns =====
-This action removes columns with no meaningful information such as empty columns, columns with all values being whitespace, or columns where all values are the same.
+This action removes columns with little or no meaningful information. It has three modes:
+  * **Remove columns where all values are empty values** - removes columns that only contain empty values (nulls)
+  * **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)
+  * **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".
@@ Line 21: / Line 27: @@
 | Small thing   |  100|    10|
+**See also**
+  * [[transformations:removeemptyrows|Remove empty rows]]