Reference Lookups

A special lookup function in the mapper enables you to call a lookup from a mapping to determine the value to populate into a field when transferring data between applications.

To reference a lookup from a data mapping:

1. Drag the source element node to a target element node to create a simple mapping.
2. In the upper right corner, click to launch the Components panel.
3. Type lookupValue in the Search field, and click Search.
4. Drag the function onto the target element node.
   The mapper prompts you to select a previously created lookup.
   
   Description of the illustration jet_mapper_lookup.png
   
5. Search by lookup name.
   When you select a lookup in the Lookup Tables column, you see preview data for that lookup on the right based on the connections you selected as the source and target.
6. Select a lookup and click Use.
7. The system automatically populates the following parameters in the lookup function:
   • dvmLocation: with the lookup name you selected
   • srcColumn: with the source application type
   • srcValue: with the existing mapping expression
   • targetColumn: with the target application type
8. Enter a defaultValue parameter. This is the value sent to the target if the lookup function is unable to find a match for the value passed from the source.
9. Click Save and Close.

Note:

Lookups referenced using the lookupValue function in the Expression Builder are included in an exported integration JAR file. When you import the integration, the referenced lookups are also imported and are visible in the Expression Builder. For information exporting integrations, see Exporting an Integration.