You are here:

Adding Source Expressions

A source expression allows you to modify the source data while you are performing the lookup. For example, let's say your source data is in upper and lower case letters, and your target is in all upper case, and it’s a case sensitive database. To ensure the lookup works correctly, add a formula to the source data, such as UPPER(S3), to format the source data just for the purposes of the lookup.

To add a source expression

Click Edit Lookup Formula i n the Edit Lookup Criteria dialog box to create or edit a source formula. The source formula can be used in lookup expressions, and optionally have a scalar function applied to it.
To change the operator used in the Lookup Link, select the operator you want from the Operator drop-down list in the Edit Lookup Criteria dialog box.

Note: The Where pane at the bottom of the dialog box displays actual function syntax in-progress.