Inserting a Data Filter

A data filter filters incoming rows using SQL criteria.

  1. Select the Data Filter tool in the Toolbox, and create the action in the diagram.
  2. Select the Data Flow tool, and draw a flow from the preceding step (a data input or action) to the data filter to initialize it with the incoming data structure columns.
  3. Double-click the data filter symbol to open its property sheet, click the Criteria tab, and enter a criterion expression to filter by.


  4. Click OK to save your changes and return to the diagram.
Note:

You can right-click a data filter symbol, and select Criteria to access the Criteria tab directly.