This shows you the differences between two versions of the page.
transformations:filterbytype [2018/05/24 03:02] (current)
|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.|
|+||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.|