Follow-On Topics

Related Topics

# About the Filter Data Tool

The Filter Data Tool is used to create a Task Step that extracts a subset of data from a recordset produced by a Database Query (ODBC), Database Query (OLEDB), or Call Stored Procedure (OLEDB) Step and provides the data for use in further Steps.

## Repository Filters

When a Task containing an Output Step that is using an Internal Memory feature is run, a Repository is automatically created for the Task containing the memorised recordset.

When a Filter Data Step is added to the Task, the Repository may be selected and a Repository Filter created within the Step. The Repository Filter is used to compare the new recordset created when the Task is run again, against the existing memorised recordset in the Repository and then set rules to filter the new subset of data produced.

## Visual Basic Filters

Again, by adding a Filter Data Step to a Task, a Visual Basic Filter may be created that applies a filter expression against the selected data source to filter the rows.

The script specified in the filter is executed once for each row in the record source. If the expression returns "true", the row is transferred to the output recordset.

## Features

|  | Single or multiple Filters

|  | Multiple data purging options

Copyright © 2018 Quadrant Software B.V. All rights reserved.