User Tools

Site Tools


transformations:filterbytype

Filter by type

This action filters values depending on their 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 "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