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.