Differences

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

--- transformations:massreplace [2015/01/29 23:10] – created dmitry
+++ 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.\\
+\\
+=====Use cases=====
+This action is typically used for data cleansing, e.g. for removing the word 'NULL' in all columns.\\
+Cleaning up the "(not set)" values that Google Analytics uses to represent blank cells.\\
+\\
+=====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).|
+\\
+=====Remarks=====
+This action is case-sensitive.  If the //Search for// value does not match values case-wise, the replacement is not made.
+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.\\
+\\
+=====Examples=====
+**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  |
+\\
+**Action parameters:**
+> Search for: "NULL"
+> where it's "Entire cell only"
+> Replace with (leave blank)
+> which is "Entire cell"
+> Perform replacement in "All columns"
+\\
+**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  |
+\\
+=====See also=====
+  * [[transformations:Lookup|Lookup]]
+  * [[transformations:match|Match]]
+  * [[transformations:replace|Replace]]
-It's typically used for data cleansing, e.g. for removing word 'NULL' in all columns.