transformations:searchfilter
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
transformations:searchfilter [2017/12/23 10:04] – created dmitry | transformations:searchfilter [2021/07/19 02:15] (current) – [Examples] craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Filter by search | + | {{ transformations: |
+ | ====== | ||
+ | Category: Transform / Filters\\ | ||
- | This transformation | + | \\ |
+ | =====Description===== | ||
+ | This action | ||
- | **Example | + | \\ |
+ | =====Use cases===== | ||
+ | Create subsets | ||
- | **Source table:** The longest rivers | + | Clean a dataset by removing records that may have " |
- | ^ | + | \\ |
- | | Nile | + | =====Action settings===== |
- | | Amazon | + | ^Setting |
- | | Yangtze | + | |Column|Select the column containing the values to be used for filtering. |
- | | Mississippi | + | |Search type|Select what part of the values should match the search string. |
- | | Yenisei | + | |Search string< |
- | | Yellow River | + | |Regular expression|This setting appears when " |
- | | Ob | 5410 | Asia | | + | |Case sensitive|When checked, case will not be considered when matching the search string.| |
- | | Paraná | + | |Filter mode|Select whether rows with matching values will be kept in the dataset, or removed. Options: //Keep only \\ matching values// or //Remove matching values//.| |
+ | < | ||
+ | \\ | ||
+ | =====Remarks===== | ||
+ | In cases where no values match the search string: | ||
+ | * If //Keep only matching values// was selected, the result will be an empty dataset. | ||
+ | * If //Remove matching rows// was selected, the result will be the full dataset (no rows removed). | ||
- | **Objective: | ||
- | **Transformation parameters:** | + | \\ |
+ | =====Examples===== | ||
+ | **Example:** Find all rivers that start with ' | ||
- | | + | **Source table:** The longest rivers in the world |
- | * Search type: Starts with | + | ^River |
- | | + | | Nile | 6650| Africa |
- | + | | Amazon | |
- | **Output | + | | Yangtze |
+ | | Mississippi | ||
+ | | Yenisei | ||
+ | | Yellow River | 5464| Asia | | ||
+ | | Ob | 5410| Asia | | ||
+ | | Paraná | ||
+ | \\ | ||
+ | **Action parameters: | ||
+ | > Column is " | ||
+ | > | ||
+ | > Search string | ||
+ | \\ | ||
+ | **Result | ||
^ River ^ Length (km) ^ Continent | ^ River ^ Length (km) ^ Continent | ||
- | | Yenisei | + | | Yangtze |
- | | Yellow River | 5464 | | + | | Yenisei |
+ | | Yellow River | 5464| Asia | | ||
+ | |||
+ | \\ | ||
+ | ====Community examples==== | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | * [[transformations: | ||
+ | * [[transformations: | ||
+ | * [[transformations: | ||
+ | * [[transformations: |
transformations/searchfilter.1514041473.txt.gz · Last modified: 2017/12/23 10:04 by dmitry