User Tools

Site Tools



This shows you the differences between two versions of the page.

Link to this comparison view

transformations:filterbytype [2018/05/24 03:02] (current)
dmitry created
Line 1: Line 1:
 +===== Filter by type =====
 +This action filters values depending on their [[syntax:types|data type]]. Filtering can be done in several columns at once. Also multiple data types can be filtered at once.
 +===Use cases===
 +Filtering by type helps detect data quality issues. It also helps ensure that columns in 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 relational database or Tableau data extract.
 +The "Filter by type" action is frequently followed by the [[transformations:halt|"Halt on condition"]] action that stops project execution if filtering returned a non-empty table with values of undesired types.
transformations/filterbytype.txt · Last modified: 2018/05/24 03:02 by dmitry