Filter block
2 min
Use a filter block to select a specific property from the input data by applying a filter. Configure the filter block with the following fields:
- Data value – Specify the property being filtered and output by this block. It can be a dataset property, such as a column, derived column, or another block.
- Filter by – Define the filter condition for the previous data value. You can organize one or more conditions into a hierarchical structure of nested and/or conditions with unlimited levels. Use the following comparison operators, noting that string comparisons are case-insensitive:
- is – Checks if the left side equals the right.
- is not – Checks if the left side does not equal the right.
- contains – Determines if the left side string contains the right side as a substring.
- in – Verifies if the left side is present within the set of values on the right side.
- <, >, >=, ... – Applies mathematical operators.
Comparing properties may include catalog properties such as columns, derived columns, blocks, values, or parameters.
Example
To filter out users in the Ads Plus and Premium tiers,
- Select the Users dataset as the actor.
- Select subscription_tier and Ads Plus and Premium values in the where field.
- Click Run.
Output
This block can be used to compute a property derived from the data by the filter block. This property may take the form of a column or another block.