What does it do?
Allows you to perform a database lookup and assign the returned values to an output column
The module allows you to define a set of database lookup actions, each with the following settings:
Settings – General
| Setting | Description | Notes |
|---|---|---|
| Name | A name given to label a lookup action | |
| Description | A description given to a lookup action to help other users understand what it does |
Settings – Source
| Setting | Description | Notes |
|---|---|---|
| Datasource Name | The selected data connection to use for the database match | |
| Datasource Type | The type of datasource to lookup against | Either “Table” or “Stored Procedure” |
| Datasource | The datasource to lookup against | Either “Table” or “Stored Procedure” |
| Datasource | The datasource to lookup against | A selected table or stored procedure |
Settings – Match
| Setting | Description | Notes |
|---|---|---|
| Input Column | The column in Loadit to match | |
| Match Column | The column in the database to match against |
Settings – Filter
Allows you to filter the records in the database before applying the matching
Settings – Return
Allows you to control which values are returned from the database and where to write them to.
Examples
None
Tips & Tricks
None