General Tools - Data Filter
The Data Filter Tool is used to create a Task Step that extracts a subset of data from a recordset produced by a Database Query (ODBC) or Call Procedure (OLEDB) Step and provides the data for use in further Steps.
When a Task containing an Output Step that is using the Memory feature is run, a Repository is automatically created for the Task containing the memorised recordset.
When a Data Filter 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.
» Third party product and technology license disclaimer
Works with other Tools
These are other Tools that this Tool will interact directly with whether by exposing information to it or consuming information from it.
Query Database
Dependencies
These are other products, technologies, protocols or systems that are required for the tool to work.
- • None
Consumes
Objects that the Tool exposes that can be utilised by other tools. Match these with ‘Consumes’ in other Tool specifications.
- • Recordset - Information Structured into Columns and Rows
- • Documents (Any) Documents of any type
Exposes
Objects that the Tool exposes that can be utilised by other tools. Match these with ‘Consumes’ in other Tool specifications.
- • Recordset - Information Structured into Columns and Rows
- • Documents (Any) Documents of any type
