Review Your Lookup Table Selections

You can review the lookup table values to use in the lookupValue function on the Summary page.

You can review the lookup table values from the Summary page. The Summary page is the final wizard page after you have completed your configuration.

Element Description

Element	Description
Parameter and Value Table	Displays a summary of the parameters and values you defined on previous pages of the wizard. To return to a previous page to update any values, click the appropriate tab in the left panel or click Back.
Resulting Expression	Displays the expression you defined on the previous pages of the wizard. The `lookupValue` function takes the following format: `lookupValue(dvmLocation, srcColumn, srcValue, targetColumn, defaultValue)` Where: `dvmLocation`: The lookup table selected on the Select Lookup Table page. `srcColumn`: The source column selected on the Select Columns page. `srcValue`: The source value you enter in the New Condition field of the Expression Builder after completing this wizard. Click Done to complete this wizard, then define the `srcValue` parameter value. `targetColumn`: The target column selected on the Select Columns page. `defaultValue`: The default value entered on the Default Value page. For example, a defined `lookupValue` function after you have completed the wizard and defined the `srcValue` parameter value in the Expression Builder can look as follows: `dvm:lookupValue('tenant/resources/dvms/Country','rightnow','US','mysoap','No data found')`

Parameter and Value Table

Displays a summary of the parameters and values you defined on previous pages of the wizard.

To return to a previous page to update any values, click the appropriate tab in the left panel or click Back.

Resulting Expression

Displays the expression you defined on the previous pages of the wizard. The lookupValue function takes the following format:

 lookupValue(dvmLocation, srcColumn, srcValue, targetColumn, defaultValue)

Where:

dvmLocation: The lookup table selected on the Select Lookup Table page.
srcColumn: The source column selected on the Select Columns page.
srcValue: The source value you enter in the New Condition field of the Expression Builder after completing this wizard. Click Done to complete this wizard, then define the srcValue parameter value.
targetColumn: The target column selected on the Select Columns page.
defaultValue: The default value entered on the Default Value page.

For example, a defined lookupValue function after you have completed the wizard and defined the srcValue parameter value in the Expression Builder can look as follows:

dvm:lookupValue('tenant/resources/dvms/Country','rightnow','US','mysoap','No data found')

When you click Done, the function icon is created in the mapper and the function XPath expression is displayed in the Expression Builder.