And/or block

  • Updated

Use an and/or block to specify conditions that yield a boolean value (true or false). You form this block by merging multiple conditions or sets of conditions using and/or operators.

Use the operator field to configure comparison operators in each condition. String comparisons are case-insensitive.

  • is – Checks if the left side equals the right side.
  • 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 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 generate a list of new users who use the .com domain,

  1. Click the property drop-down list and select the New Users cohort in the where field. Learn how to create cohorts.
  2. Set the value to True. 
  3. Click the property drop-down list and select the Is Dot Com Domain cohort in the and field. 
  4. Set the value to True.
  5. Click Run.
oa-andorblock.png

Output

The output of the and/or block is a boolean value.