Differences

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

--- transformations:massreplace [2015/04/10 16:05] – elenap
+++ transformations:massreplace [2021/07/19 02:17] (current) – [Examples] craigt
@@ Line 1: / Line 1: @@
-===== Table-wide replace =====
+{{ transformations:MassReplaceAction.png}}
+====== TABLE-WIDE REPLACE ======
+Category: Transform / Advanced\\
-This transformation performs the same replacement in all or selected columns.
+\\
+=====Description=====
+This action performs the same replacement in all or selected columns.\\
-It's typically used for data cleansing, e.g. for removing word 'NULL' in all columns.
+\\
+=====Use cases=====
+This action is typically used for data cleansing, e.g. for removing the word 'NULL' in all columns.\\
-EXAMPLE
+Cleaning up the "(not set)" values that Google Analytics uses to represent blank cells.\\
-**Source table:** The longest rivers in the world
+\\
+=====Action settings=====
+^Setting^Description^
+|Search for|Enter the value to search for.|
+|where it's|Select whether to match whole-cell values, or whole-cell values //and// partial values.  Options:  //Entire cell only// or //Entire cell or part of longer text//.|
+|Replace with|Enter the value to replace the search value with.|
+|which is|Select whether the replacement value will occupy the entire cell or just the matching portion of the found search value.  Options:  //Entire cell// or //Matching part//.|
+|Perform replacement in|Select whether to search all or specific columns.  Options: //All columns// or //Selected columns// (and select the column(s) to search from the list).|
-^  River  ^  Length (km)  ^  Continent  ^
+\\
-| Nile  |  6650  |  Africa  |
+=====Remarks=====
-| Amazon  |  6400  |  South America  |
+This action is case-sensitive.  If the //Search for// value does not match values case-wise, the replacement is not made.
-| Yangtze  |  6300  |  Asia  |
-| Mississippi  |  6275  |  North America  |
+Numeric values can only be searched for, and replaced as, entire cell values.  Upon entering a numeric value in the //Search for// field, only the //Entire cell only// options will be selectable.\\
-| Yenisei  |  5539  |  Asia  |
-| Yellow River  |  5464  |  Asia  |
+\\
-| Ob  |  5410  |  Asia  |
+=====Examples=====
-| Paraná  |  4880  |  South America  |
+**Example:** Clean out NULL values from the source table, replacing them with blank cells.\\
+**Source table:** The longest rivers in the world
+^River  ^Length (km)  ^Continent  ^
+| Nile  |  6650|Africa  |
+| NULL  |  6400|South America  |
+| Yangtze  |  6300|NULL  |
+| Mississippi  |NULL  |North America  |
+| Yenisei  |  5539|Asia  |
+| Yellow River  |  5464|NULL|
+| Ob  |NULL  |NULL  |
+| Paraná  |  4880|South America  |
-**Objective:** Replace "North America" or "South America" by simply "America"
+\\
+**Action parameters:**
+> Search for: "NULL"
+> where it's "Entire cell only"
+> Replace with (leave blank)
+> which is "Entire cell"
+> Perform replacement in "All columns"
-**Transformation parameters:**
+\\
+**Result table:**
+^River  ^Length (km)  ^Continent  ^
+| Nile  |  6650|Africa  |
+|  |  6400|South America  |
+| Yangtze  |  6300|  |
+| Mississippi  |  |North America  |
+| Yenisei  |  5539|Asia  |
+| Yellow River  |  5464|  |
+| Ob  |  |  |
+| Paraná  |  4880|South America  |
-  * Search for: America
+\\
-  * where it's: Entire cell or part of longer text
+=====See also=====
-  * Replace with: America
+  * [[transformations:Lookup|Lookup]]
-  * which is: Entire cell
+  * [[transformations:match|Match]]
-  * Perform replacement in: All columns
+  * [[transformations:replace|Replace]]
-**Output table:**
-^  River  ^  Length (km)  ^  Continent  ^
-| Nile  |  6650  |  Africa  |
-| Amazon  |  6400  |  America  |
-| Yangtze  |  6300  |  Asia  |
-| Mississippi  |  6275  |  America  |
-| Yenisei  |  5539  |  Asia  |
-| Yellow River  |  5464  |  Asia  |
-| Ob  |  5410  |  Asia  |
-| Paraná  |  4880  |  America  |