The Lookup transform joins data from input columns with column in a lookup table.

Transform - Lookup
Transform - Lookup

1. Input

The Lookup transform requires 2 input transforms.

For example, the input could be a SQL Select transform that corresponds to the following SQL Server tables (AdventureWorks):

2. Configure

In the Lookup configuration dialog, you must configure the following settings:

Lookup configuration dialog
Lookup configuration dialog

  1. In the Input Table pane, select the columns you want to be included on the output.
  2. Drag and Drop the key column from the Input Table pane to the Lookup Table pane's matching key column.
  3. In the Lookup Element section, select the column name you want to be included in the output.
  4. Select Omit Non Matches if needed.

3. Output

The figure below illustrates the output from the Lookup transform.

Lookup output example
Lookup output example

4. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri