transformations:filterbytype
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
transformations:filterbytype [2021/04/26 00:21] – craigt | transformations:filterbytype [2021/07/15 11:51] – craigt | ||
---|---|---|---|
Line 10: | Line 10: | ||
=====Use cases===== | =====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. | 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: | ||
\\ | \\ | ||
Line 18: | Line 16: | ||
|Filter mode|Select whether to keep or remove values of the types specified. | |Filter mode|Select whether to keep or remove values of the types specified. | ||
|Data types|Select the data types to be filtered by. Options: | |Data types|Select the data types to be filtered by. Options: | ||
- | |Columns to check|Select whether to check the entire table or specific columns. | + | |Columns to check|Select whether to check the entire table or specific columns. |
\\ | \\ | ||
Line 54: | Line 52: | ||
| Yellow River | 5464| Asia | | | Yellow River | 5464| Asia | | ||
| Ob | 5410| Asia | | | Ob | 5410| Asia | | ||
+ | |||
+ | \\ | ||
+ | ====Community examples==== | ||
+ | * [[https:// | ||
\\ | \\ | ||
Line 60: | Line 62: | ||
* [[transformations: | * [[transformations: | ||
* [[transformations: | * [[transformations: | ||
+ | * [[transformations: |
transformations/filterbytype.txt · Last modified: 2021/07/19 02:14 by craigt