Lookup Tables
Use Lookup Tables to create links between associated values in your source and target data, such as a product name in the source and its product code in the target.
For example, your Inventory data source may have a field called Chocolate which is populated with picklist values of 1, 2 and 3, while the Candy data target has an equivalent field, but stores values of "Milk Chocolate", "Dark Chocolate", and "Bittersweet Chocolate" to represent the equivalent settings in that field. You can create a Lookup Table that maps the value of 1 or Chocolate in the source system to the value "Milk Chocolate" in the equivalent field in the target system:
Inventory | Candy |
---|---|
1 |
Milk Chocolate |
2 |
Dark Chocolate |
3 |
Bittersweet Chocolate |
Once you create a Lookup Table, you can use one of the Lookup Table functions to use a value in one data source to find its associated value in another data source:
- For LOOKUPTABLEVALUE1 or LOOKUPTABLEVALUE2, if the associated value is not found, TIBCO Cloud™ Integration - Connect returns an error and the record is not processed.
- For LOOKUPTABLEVALUE1_DEFAULT or LOOKUPTABLEVALUE2_DEFAULT if the associated value is not found, a default value, such as ERROR or UNKNOWN, is entered into the target record.
From the Lookup Tables page you can: