Filter block

  • Updated

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,

  1. Select the Users dataset as the actor.
  2. Select subscription_tier and Ads Plus and Premium values in the where field.
  3. Click Run.
oa-filterblock.png

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.