Using components: Assert Transformation

Use the Assert transformation to make sure that all data in the source complies with the conditions you specify in this component. If a record does not comply, the job fails and a message is added to the error log.

Error message

Type the error message that will be thrown to the log if a record does not comply with the conditions you specify below.

Conditions

Logical operator

By default, a record must match all the conditions.

  • Match all of the following conditions (AND) - selects records with values that meet all conditions specified (logical "AND")
  • Match any of the following conditions (OR) - selects records with values that meet at least one of the conditions specified (logical "OR")
  • Match none of the following conditions (NOT) - selects records with values that doesn't meet any of the conditions specified (NOT ( ... OR ...))

Specifying conditions

Each condition comprises of an expression (or field), a comparison operator, and possibly another value or expression to compare with (depending on the operator).

  • Expression (left-hand) - In the drop-down list on the left, select a field or edit an expression. (You can read more about expressions and functions).
  • Operator - Select the operator from the following list:
    Operator Description
    text equals The expression on the left must be equal to the string value on the right. The text should not be enclosed in quotes or escaped.
    text not equals The expression on the left must not be equal to the string value on the right. The text should not be enclosed in quotes or escaped.
    text matches The expression on the left must must match the regular expression string value on the right. The text should not be enclosed in quotes or escaped. For example, matching a string field with .*dog.* would pass any string that contains the string dog: dog, dogs, adogmatic
    text is empty The expression on the left must be empty.
    text is not empty The expression on the left must not be empty.
    = The expression on the left must be equal to the expression on the right.
    != The expression on the left must not be equal to the expression on the right.
    > The expression on the left must be greater than the expression on the right.
    >= The expression on the left must be greater than or equal to the expression on the right.
    < The expression on the left must be less than the expression on the right.
    <= The expression on the left must be less than or equal to the expression on the right.
    is null The expression on the left must be null.
    is not null The expression on the left must not be null.
    is true The expression on the left must true - especially useful when left hand side is a complex expression.
  • Value/Expression - with text operators, type the text or pattern to compare to. With other operators, pick a field or edit an expression.