Differences

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

--- transformations:cleanup [2016/06/19 19:54] – created dmitry
+++ transformations:cleanup [2021/03/30 22:18] – craigt
@@ Line 1: / Line 1: @@
-===== Clean up =====
+{{ transformations:CleanUpAction.png}}
+====== CLEAN UP ======
+Category: Transform / Basic\\
-Remove from column particular values or values of a particular type (e.g. text) by replacing them with empty cells. Unlike [[transformations:selectionfilter|Filter]] this transformation doesn't remove table rows.
+\\
+=====Description=====
+This action removes specified values, or values of a particular type (e.g. text), from a column by replacing them with empty cells.
-**Use cases**
+Unlike [[transformations:selectionfilter|Filter]], this transformation doesn't remove table rows.
-Clean Up is used for dealing for data quality issues. E.g. removing text values from a column where only numbers are expected, or removing particular (garbage) values. Most typically, Clean Up is used when importing data from Excel spreadsheets.
+ \\
+\\
+=====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.\\
+\\
+=====Action settings=====
+^Setting^Description^
+|Column|Select the specific column that values will be cleaned from.|
+|Remove…|Select the types of values, or specific values, to be removed.  See below.|
+\\
+====Remove options====
+^Option^Description^
+|Remove numbers|All numeric values are removed.|
+|Remove everything but numbers|All numbers are kept; non-numeric values are removed.|
+|Remove text values|All text values are removed.|
+|Remove everything but text values|Text values are kept; non-text values are removed.|
+|Remove whitespace only values|Removes values containing only spaces.|
+|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.|
+\\
+=====Shortcuts=====
+Fast ways to create the action:\\
+  *Right-click a value and select "Clean Up".  Choose whether to "Keep only [value]" or "Remove [value]" from the submenu.
+\\
+=====See also=====
+  * [[transformations:Replace|Replace]]