transformations:filterbytype
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
transformations:filterbytype [2018/05/23 23:02] – created dmitry | transformations:filterbytype [2021/07/19 02:14] (current) – [Examples] craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Filter by type ===== | + | {{ transformations: |
+ | ====== | ||
+ | Category: Transform / Filters\\ | ||
- | This action filters values depending on their [[syntax: | + | \\ |
+ | =====Description===== | ||
+ | This action filters values depending on their [[syntax: | ||
- | ===Use cases=== | + | \\ |
- | Filtering by type helps detect data quality issues. It also helps ensure | + | =====Use cases===== |
+ | Filtering by type helps detect data quality issues | ||
- | The "Filter | + | \\ |
+ | =====Action settings===== | ||
+ | ^Setting ^Description ^ | ||
+ | |Filter | ||
+ | |Data types|Select the data types to be filtered by. Options: | ||
+ | |Columns to check|Select whether to check the entire table or specific columns. | ||
+ | |||
+ | \\ | ||
+ | =====Remarks===== | ||
+ | In cases where no values match the search string: | ||
+ | * If //Keep only values…// was selected, the result will be an empty dataset. | ||
+ | * If //Remove values…// was selected, the result will be the full dataset (no rows removed). | ||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | **Example: | ||
+ | |||
+ | **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: | ||
+ | > Filter mode is "Keep only values of selected type(s)" | ||
+ | > Data types: | ||
+ | > Columns to check; Particiular columns: | ||
+ | \\ | ||
+ | **Result table:** | ||
+ | ^River | ||
+ | | Nile | 6650| Africa | ||
+ | | Amazon | ||
+ | | Mississippi | ||
+ | | Yenisei | ||
+ | | Yellow River | 5464| Asia | | ||
+ | | Ob | 5410| Asia | | ||
+ | |||
+ | \\ | ||
+ | ====Community examples==== | ||
+ | * [[https:// | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | * [[transformations: | ||
+ | * [[transformations: | ||
+ | * [[transformations: | ||
+ | * [[transformations: |
transformations/filterbytype.txt · Last modified: 2021/07/19 02:14 by craigt