A data filter filters incoming rows using SQL criteria.
- Select the Data Filter tool in the Toolbox, and create the action in the diagram.
- 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.
- Double-click the data filter symbol to open its property sheet, click the Criteria tab, and enter a criterion expression to filter by.
- 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.
