Lookup Transformation Editor (Columns Page)

Available Input Columns

View the list of available input columns. The input columns are the columns in the data flow from a connected source. The input columns and lookup column must have matching data types.

Use a drag-and-drop operation to map available input columns to lookup columns.

You can also map input columns to lookup columns using the keyboard, by highlighting a column in the Available Input Columns table, pressing the Application key, and then clicking Edit Mappings.

Available Lookup Columns

View the list of lookup columns. The lookup columns are columns in the reference table in which you want to look up values that match the input columns.

Use a drag-and-drop operation to map available lookup columns to input columns.

Use the check boxes to select lookup columns in the reference table on which to perform lookup operations.

You can also map lookup columns to input columns using the keyboard, by highlighting a column in the Available Lookup Columns table, pressing the Application key, and then clicking Edit Mappings.

Lookup Column

View the selected lookup columns. The selections are reflected in the check box selections in the Available Lookup Columns table.

Lookup Operation

Select a lookup operation from the list to perform on the lookup column.

Output Alias

Type an alias for the output for each lookup column. The default is the name of the lookup column; however, you can select any unique, descriptive name.

Reference

Concepts