Filter Examples (In Database)
(In-Database Processing)
Synopsis
Keeps only those rows that satisfy a certain criteria.Description
This operator filters the set of rows based on the criteria defined either by an expression (where you can use your database-specific functions as well), or by a combination of simple expressions. A dialog that you can access by clicking on the appropriate button helps in both cases.
When constructing the filter expression, you may find the built-in macros like process_start_db and t_db useful. Please check the Nest operator help for more information.
Input
example set input
Output
- example set output
Parameters
- condition class Implementation of the condition.
- filters Defines the list of filters to apply.
- parameter expression Parameter string for the expression, e.g. 'attribute1 = attribute2'. Put identifiers containing reserved keywords or special characters into square brackets ([]). The square brackets will be replaced by database specific escaping characters (e.g. backticks(`) for Google BigQuery). Uncheck the 'replace square brackets' parameter to disable replacement.
- replace square brackets Replace square brackets. By default square brackets are replaced by the database specific characters used for escaping special identifiers (e.g. with backticks(`) for Google BigQuery). In some situations you may not want to replace the square brackets in the expression. Uncheck this parameter to do so.
- filters list The list of filters.
- filters logic and Logic operator for filters.
- filters check metadata Check meta data for comparators.