This component allows to lookup values in a database. The lookup data is specified by the result set of a query returning exactly two columns: the lookup key and the lookup value. The value returned (lookup value) by the lookup can be assigned to any attribute of the current record. The lookup table will be cached during execution of the project. Changes applied to the underlying database during project execution have no effect on the lookup result.
Use this component, when your lookup data can be retrieved directly from a database.
Add the component to the project and connect the ports to adjacent components.
