Skip to main content

​
Overview:

The Filter block is designed to selectively pass through data based on specific criteria, allowing you to refine or eliminate undesired elements from a list. It supports a range of condition types such as handling empty values, performing numerical comparisons, evaluating boolean states, and matching text-based conditions. This block plays a vital role in workflows where data validation and cleansing are essential by ensuring that only entries meeting the defined criteria are processed.

​
Inputs & Outputs

​
Available List of Conditions

  • Is empty: Confirms if an entry has no content.
  • Is not empty: Validates whether there’s content present.
  • [Number] is greater than: Checks for numbers exceeding a given threshold.
  • [Number] is less than: Validates numbers falling below specified limits.
  • [Number] is equal to: Verifies if numbers match exactly with expected values.
  • [Boolean] is true: Ensures only true values pass through from boolean fields.
  • [Boolean] is false: Ensures only false values pass through from boolean fields.
  • [Text] is exact match of: Validates that strings completely correspond with given benchmarks without deviation.
  • [Text] contains: Checks whether strings have specific segments included within them.
  • [Text] does not contain: Filters out strings lacking certain specified segments or words.
  • [Text] starts with: Verifies that strings commence with defined prefixes for targeted inclusion in results.
  • [Text] does not start with: Excludes items whose string representations do not start according to specifications provided here .
  • [Text] ends with: Checks if strings conclude appropriately according particular suffix requirements outlined here . -** [Text ] does not end** :Excludes unintended matches by confirming final determined suffixes prior established parameters .

​
Use Cases

Imagine how this block can enhance your data processing tasks:
  1. Filtering Out Records: Efficiently remove records failing certain benchmarks—for example, excluding customers younger than legal age or products priced beyond budget constraints during inventory assessments.
  2. Empty Value Handling: Utilized effectively within large datasets across different collections—to isolate rows containing complete information by focusing solely upon populated attributes where critical analyses must take place .
3 . _ Boolean Field Subsetting :_ Streamlining decisions involving flags¾ leveraging this technology allows analyses limited strictly just selecting options classified either “true” versus “false”. 4 ._ String Processing :_ Specifically target only terms featuring known keywords; forward-thinking marketers may course correct messaging strategy accordingly.*; a retail manager may actively manage what inventory enters promotional functions ” In essence , wherever filtering down lists based upon relevant qualifications aids better clarity/consolidation +safeguards usability integrity…the “Filter” Block proves invaluable!