Filter
The Filter transform evaluates records from a dataset using a VBScript expression entered as a Script Formula. The records where the expression evaluates to False are deleted from the resultant dataset, while those that evaluate to True are kept.
Order of Execution
Records are processed from child to parent. This means that a child record’s filter expression will have executed prior to its parent (see Data Processing Pattern).
The VBScript Function expression can use functions such as Count, Sum, Less Than, and Greater Than.
Filter > Audit
Supported Counters
- PROCESSED
- Incremented for each record processed.
- DELETED
- Incremented for each record filtered from the transaction.
- ERRORS
- Incremented for each non-handled error on a formula.
Action on Transform Error
It is highly recommended this is set to Abort. Setting to Reject Record or Continue will allow IMan to continue processing irrespective of an error AND may cause records to be erroneously filtered from the dataset.