Category: Transform / Filters

This action filters values depending on their data type. Filtering can be applied to several columns at once, as well as multiple data types.

Filtering by type helps detect data quality issues by ensuring that columns in the 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 a relational database or a Tableau data extract.

In cases where no values match the search string:

• If Keep only values… was selected, the result will be an empty dataset.
• If Remove values… was selected, the result will be the full dataset (no rows removed).

Example: Filter out all non-numberic values in the "Length (km)" column.

Source table: The longest rivers in the world

Action parameters:

Filter mode is "Keep only values of selected type(s)"
Data types: "Number" selected
Columns to check; Particiular columns: "Length (km)"

Result table:

• Extracting all projects published in the Community and their actions (Project; Module: Get projects; Group: Tab 1; Table: Project links; Action position: 4)

• Filter
• Filter by condition
• Filter by search
• Halt on data type mismatch