You can use a lookup table to insert a value into a field in a message. The filter searches a user-specified column in a lookup table for a particular value. If it finds the value, it replaces the value in the field with the value in a user-specified column in the lookup table. If no value is found, it can take a number of user-specified actions.

To modify a target operand using a lookup table:

  1. Select the target operand.

  2. Select the Using a Lookup Table action operator to display the Lookup Table Action form:

  3. Enter the values in the following form fields:

    Form Field

    Description

    Table Name

    Enter the name of the table.

    Search Column

    Enter the column to search in.

    Using Value From

    Enter the value to search for.

    Replace With Value in Column

    Enter the column from which to insert a value into the target operand if a value is found in the searched column.

    If No Value Found Then

    From the drop-down list select one of the following actions if no value is found:
    • Abort (Error)
    • Use Existing Value
    • Use A Default Value
  4. Click the Ok link to save your changes, or the Cancel link to discard them.