Help and Support > Table of Contents > Filter



The Filter block provides the ability to apply a filter to a data set. To do this, any expression can be used, looking at multiple columns, parsing text, doing mathematical manipulation and logical operations, as long as the result of the calculation is TRUE the record will be passed, otherwise it will be rejected. In the event of data type issues, records are collected on the Error stub.

Filter Image

Block Connection Stubs

  • 1 The data source that is to be filtered.
  • 2 The top output contains all the data that passed the filter criteria.
  • 3 The middle output contains all the data that did not pass the filter criteria.
  • 4 The Error output contains all the rows that could not be evaluated because the data types and/or data were incorrect for the filter conditions.