Specifying the filter

Lists the elements that you can use for specifying the expressions. The operation of the filter stage is governed by the expressions that you set.

The operation of the filter stage is governed by the expressions you set in the Where property on the Properties tab. You can use the following elements to specify the expressions:

  • Input columns.
  • Requirements involving the contents of the input columns.
  • Optional constants to be used in comparisons.
  • The Boolean operators AND and OR to combine requirements.

When a record meets the requirements, it is written unchanged to the specified output link. The Where property supports standard SQL expressions, except when comparing strings.

When quoting in the filter, you should use single, not double, inverted commas.