Differences

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

--- 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: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".
+=====Remarks=====
+If the dataset has columns but no data (i.e. no rows), the action does nothing.
-**Example**
+\\
+=====Examples=====
-Source dataset:
+**Example:** Remove empty columns.\\
-^ 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|
 | | Medium thing  | |   10| |   100|
 | | Small thing   | |  100| |    10|
+\\
+**Action parameters:**
+>All values are empty values.
-Objective: remove empty columns.
+\\
+**Result table:**
-Result:
 ^ Product name ^ Qty ^ Price ^
 | Big thing     |    1|  1000|
@@ Line 27: / Line 48: @@
 | Small thing   |  100|    10|
-**See also**
+\\
+====Community examples====
+  * [[https://community.easymorph.com/t//2053/9|Converting Text to HTML]] ([[https://community.easymorph.com/uploads/short-url/3acTPpAroyvp3DsTPNTOZQIqaHO.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 1//; Action position: //3//)
+  * [[https://community.easymorph.com/t//2711/2|My first experiment API + conditional workflow + iteration]] ([[https://community.easymorph.com/uploads/short-url/jG4qopOtRfSxDo0UFJkNbBaKvac.morph|Project]]; Module: //Process Network ID//; Group: //Acquisition data via API//; Table: //Data from API//; Action position: //2//)
+  * [[https://community.easymorph.com/t//2711/2|My first experiment API + conditional workflow + iteration]] ([[https://community.easymorph.com/uploads/short-url/jG4qopOtRfSxDo0UFJkNbBaKvac.morph|Project]]; Module: //Process Network ID//; Group: //Result//; Table: //Result//;\\ Action position: //3//)
+\\
+=====See also=====
   * [[transformations:removeemptyrows|Remove empty rows]]