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.

The IMan (VB)Script Language Reference expression can be a simple boolean expression, use functions such as Count, Sum, Less Than, and Greater Than or have complex multi-line expressions such as that shown below.

The last line of the filter expression must contain the result i.e. an expression returning a true/false value. This can simply be the single line filter expression OR the result of a multiline expression (shown below).

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).

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.