Follow-On Topics

Related Topics

# About the External Lookup Function

Through the External Lookup Function dialog box a function may be created to obtain data from an external database using ODBC or OLEDB data connections. The function looks up a value in an external database column and returns a value from another column.

The dialog box is displayed by either double-clicking on the icon in the Functions Pane or dragging and dropping the icon from the Functions Pane onto the Mapping and Functions Panel and then double-clicking on the icon. It contains the items through which an External Lookup function may be configured:

|  | Function Name — A name for the function may be manually entered.

|  | Tabbed Panes — The dialog box includes the six tabbed panes listed below:

|  | Inputs

|  | Output

|  | Options

|  | Data Source

|  | Columns

|  | Query

Copyright © 2018 Quadrant Software B.V. All rights reserved.