Use Lookups in Variable Assignments

You can create variable assignments that use lookups in the Expression Builder. You must have already created the lookup.

1. Create a lookup in Oracle Integration. See Manage Lookups.

2. Drag an Assign action to the + sign. You can also create variable assignments that use lookups in other actions that use functions (for example, a data stitch action).

3. Enter a name and optional description.

4. Select String from the Datatypes drop-down list.
5. Click Switch to Developer Mode

6. Click the Functions tab in the Sources tree.

7. Drag the lookupValue function to the Value field. You can use search to access this function.

   This starts the Map Lookup Value Wizard.

   
   
   

8. Select the lookup to use, and click Next >.

9. Select the source and target columns, and click Next >.

10. Enter a default value, and click Next >.

11. Review your selections on the Summary page and note the srcValuePlaceHolder value to replace in the expression, then click >.

    
    
    

12. Click the Input Sources tab.

13. In the Sources tree, drag a value (for this example, $tracking_var_1) on top of the srcValuePlaceHolder value.

    
    
    

    The expression appears as follows:

    
    
    

14. Click Save.

    Lookup functions are available for use in the target tree of the mapper.