Database Match

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