Lookup Criteria Tab

The Lookup Criteria tab at the bottom of the main window lists all of the Lookup links defined for the current DTS file. New Lookup Links default to exact-match links when they are created, such as "where company_id = comp_id".

The content displayed by the tab depends on the filter setting, as configured by the drop-down menu in the upper-right corner of the target pane.

To edit Lookup Criteria for a Lookup Link

To view or edit a link comment

Tip: To resize columns, drag the dividers between the column headings.

To sort a column in the Lookup Criteria tab, click the column header.

See also

Creating Lookup Links

Data Formulas tab popup menu

Filtering Target Steps

Viewing Field Properties

Using Scalar Functions in Lookup Links

Using Source Expressions

Using Operators in a Lookup Expression

About Lookup Expressions