Stratus Cloud Solutions Stratus Docs
Documentation / Data Cleanser User Guide / Building Scenarios

Filters & Advanced Logic

Filters limit which records the scan includes. On the Filters step, click Add filter, then pick a field, an operator, and a value. Each filter row has an edit and a delete icon.

By default, all filters must be true (AND). For custom combinations, use Add advanced logic — for example 1 AND (2 OR 3) where numbers refer to filter rows.

Filter operators reference
  • Equals / Does not equal
  • Starts with / Does not start with
  • Ends with
  • Contains / Does not contain
  • Greater than / Greater than or equal
  • Less than / Less than or equal
  • Is blank / Is not blank
Advanced logic — validation and tips

Click Validate logic to check your expression before applying with Done. The validator catches:

  • Unbalanced parentheses
  • Unknown text in the expression
  • References to filters that don't exist (e.g. filter 5 when only 3 are defined)
  • Filters you defined but forgot to reference in the expression

Use Edit advanced logic later to revise the expression as you add or remove filters — and re-validate after every change.