User Tools

Site Tools


transformations:filterbytype

Differences

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