User Tools

Site Tools


transformations:filterbytype
no way to compare when less than two revisions

Differences

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


Next revision
transformations:filterbytype [2018/05/23 23:02] – created dmitry
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: 2021/07/19 02:14 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki