Differences

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

--- transformations:cleanup [2021/03/30 22:18] – craigt
+++ transformations:cleanup [2024/04/12 00:35] (current) – craigt
@@ Line 5: / Line 5: @@
 \\
 =====Description=====
-This action removes specified values, or values of a particular type (e.g. text), from a column by replacing them with empty cells.
+This action removes specified values, or values of a particular type (e.g. text), from one or more columns by replacing them with empty cells.\\
-Unlike [[transformations:selectionfilter|Filter]], this transformation doesn't remove table rows.
- \\
 \\
 =====Use cases=====
-//Clean Up// is used for dealing with data quality issues - e.g. removing text values from a column where only numbers are expected, or removing specific undesired values. Most typically, //Clean Up// is used when importing data from Excel spreadsheets.\\
+//Clean Up// is used for dealing with data quality issues - e.g. removing text values from columns where only numbers are expected, or removing specific undesired values. Most typically, //Clean Up// is used when importing data from Excel spreadsheets.\\
 \\
 =====Action settings=====
 ^Setting^Description^
-|Column|Select the specific column that values will be cleaned from.|
+|Column|Click the down arrow to choose which columns Clean Up will affect.  Options:  //Column// (and select a specific column), //All columns// (to clean the entire dataset), or //Selected columns// (and select which columns will be cleaned).|
 |Remove…|Select the types of values, or specific values, to be removed.  See below.|
 \\
@@ Line 29: / Line 26: @@
 |Remove errors|All error results are removed.|
 |Remove particular values|Options:  //Remove selected values// or //Remove all but selected//.  When selected, a list of all unique\\ values in the column is displayed for the user to manually select which values to keep or remove.|
+\\
+=====Remarks=====
+Unlike [[transformations:selectionfilter|Filter]], this transformation doesn't remove table rows.\\
+\\
+=====Community examples=====
+  * [[https://community.easymorph.com/t//1375/5|Example: Getting public holidays from an API with Web Request]] ([[https://community.easymorph.com/uploads/short-url/pL0iYCFfb1g8rGHfNBMZd1rAd8k.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Public holidays//;\\ Action position: //4//)
+  * [[https://community.easymorph.com/t//2017/3|Duplicating rows based on a condition]] ([[https://community.easymorph.com/uploads/short-url/blETeOO6qUVzskyO2eYqMiNvjPP.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 1 (2)//; Action position: //5//)
 \\