transformations:filterbytype
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:filterbytype [2021/04/26 00:42] – [Action settings] craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | {{ transformations: | ||
+ | ====== FILTER BY TYPE ====== | ||
+ | Category: Transform / Filters\\ | ||
+ | \\ | ||
+ | =====Description===== | ||
+ | This action filters values depending on their [[syntax: | ||
+ | |||
+ | \\ | ||
+ | =====Use cases===== | ||
+ | Filtering by type helps detect data quality issues by ensuring that columns in the exported dataset are strongly typed (i.e. all values in a column are of the same type). This might be required before exporting into a target system with strongly typed fields, such as a relational database or a Tableau data extract. | ||
+ | |||
+ | The //Filter by type// action is frequently followed by the [[transformations: | ||
+ | |||
+ | \\ | ||
+ | =====Action settings===== | ||
+ | ^Setting ^Description ^ | ||
+ | |Filter mode|Select whether to keep or remove values of the types specified. | ||
+ | |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===== | ||
+ | **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: | ||
+ | > Filter mode is "Keep only values of selected type(s)" | ||
+ | > Data types: | ||
+ | > Columns to check; Particiular columns: | ||
+ | \\ | ||
+ | **Result:** | ||
+ | ^River | ||
+ | | Nile | 6650| Africa | ||
+ | | Amazon | ||
+ | | Mississippi | ||
+ | | Yenisei | ||
+ | | Yellow River | 5464| Asia | | ||
+ | | Ob | 5410| Asia | | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | * [[transformations: | ||
+ | * [[transformations: | ||
+ | * [[transformations: |
transformations/filterbytype.txt · Last modified: 2021/07/19 02:14 by craigt