transformations:searchfilter
no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
Previous revisionNext revision | |||
— | transformations:searchfilter [2021/04/25 21:51] – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | {{ transformations: | ||
+ | ====== FILTER BY SEARCH ====== | ||
+ | Category: Transform / Filters\\ | ||
+ | \\ | ||
+ | =====Description===== | ||
+ | This action keeps or removes rows where values in a specified column contain a particular substring. It also supports filtering using a regular expression.\\ | ||
+ | |||
+ | \\ | ||
+ | =====Use cases===== | ||
+ | Create subsets of a dataset based on parts of values in a specific column (literal strings or regular expressions). | ||
+ | |||
+ | Clean a dataset by removing records that may have " | ||
+ | |||
+ | \\ | ||
+ | =====Action settings===== | ||
+ | ^Setting ^Description ^ | ||
+ | |Column|Select the column containing the values to be used for filtering. | ||
+ | |Search type|Select what part of the values should match the search string. | ||
+ | |Search string< | ||
+ | |Regular expression|This setting appears when " | ||
+ | |Case sensitive|When checked, case will not be considered when matching the search string.| | ||
+ | |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). | ||
+ | |||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | **Objective: | ||
+ | |||
+ | **Source table:** The longest rivers in the world | ||
+ | ^River | ||
+ | | Nile | 6650| Africa | ||
+ | | Amazon | ||
+ | | Yangtze | ||
+ | | Mississippi | ||
+ | | Yenisei | ||
+ | | Yellow River | 5464| Asia | | ||
+ | | Ob | 5410| Asia | | ||
+ | | Paraná | ||
+ | \\ | ||
+ | **Action parameters: | ||
+ | > Column is " | ||
+ | > Search type is " | ||
+ | > Search string is " | ||
+ | \\ | ||
+ | **Result:** | ||
+ | ^ River ^ Length (km) ^ Continent | ||
+ | | Yangtze | ||
+ | | Yenisei | ||
+ | | Yellow River | 5464| Asia | | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | * [[transformations: | ||
+ | * [[transformations: | ||
+ | * [[transformations: |
transformations/searchfilter.txt · Last modified: 2021/07/19 02:15 by craigt