transformations:massreplace
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| transformations:massreplace [2021/04/28 14:28] – [Examples] dmitry | transformations:massreplace [2021/07/19 02:17] (current) – [Examples] craigt | ||
|---|---|---|---|
| Line 10: | Line 10: | ||
| =====Use cases===== | =====Use cases===== | ||
| This action is typically used for data cleansing, e.g. for removing the word ' | This action is typically used for data cleansing, e.g. for removing the word ' | ||
| + | |||
| + | Cleaning up the "(not set)" values that Google Analytics uses to represent blank cells.\\ | ||
| \\ | \\ | ||
| Line 29: | Line 31: | ||
| =====Examples===== | =====Examples===== | ||
| - | **Objective:** Replace "North America" | + | **Example:** Clean out NULL values from the source table, replacing them with blank cells.\\ |
| **Source table:** The longest rivers in the world | **Source table:** The longest rivers in the world | ||
| Line 35: | Line 37: | ||
| ^River | ^River | ||
| | Nile | 6650|Africa | | Nile | 6650|Africa | ||
| - | | Amazon | + | | NULL |
| - | | Yangtze | + | | Yangtze |
| - | | Mississippi | + | | Mississippi |
| | Yenisei | | Yenisei | ||
| - | | Yellow River | 5464|Asia | + | | Yellow River | 5464|NULL| |
| - | | Ob | | + | | Ob |NULL |NULL | |
| | Paraná | | Paraná | ||
| \\ | \\ | ||
| **Action parameters: | **Action parameters: | ||
| - | > Search for: "America" | + | > Search for: "NULL" |
| - | > where it's: Entire cell or part of longer text | + | > where it' |
| - | > Replace with: " | + | > Replace with (leave blank) |
| - | > which is: Entire cell | + | > which is "Entire cell" |
| - | > Perform replacement in: All columns | + | > Perform replacement in "All columns" |
| \\ | \\ | ||
| - | **Output | + | **Result |
| ^River | ^River | ||
| | Nile | 6650|Africa | | Nile | 6650|Africa | ||
| - | | Amazon | + | | | 6400|South America |
| - | | Yangtze | + | | Yangtze |
| - | | Mississippi | + | | Mississippi |
| | Yenisei | | Yenisei | ||
| - | | Yellow River | 5464|Asia | | + | | Yellow River | 5464| | |
| - | | Ob | | + | | Ob | | | |
| - | | Paraná | + | | Paraná |
| \\ | \\ | ||
transformations/massreplace.txt · Last modified: 2021/07/19 02:17 by craigt