Editing Lookup Tables

To edit an existing lookup table:

Procedure

  1. Select the Functions tab. In the Function tab, the list of standard functions shows. In addition, the Actions pane is displayed.
  2. In the Function tab, expand Lookup Tables.
  3. Select the table to edit.
  4. To display the Lookup Table dialog box, choose from one of the following options:
    • Right-click the table node in the Functions tab and from the menu select Edit....
    • In the Actions pane, select Add New Lookup Table.
    The Lookup Table dialog box opens.
  5. Edit your table using one of the following actions:
    • Add a Key Value pair - To add another key value pair to your table, follow these steps:
      1. Click Add.
      2. In the Key field, enter the name of the key. During run time, this key will be replaced by the specified value.
      3. In the Value field, enter the value that the key will be translated to during run time. Press the Return key.
    • Delete a Key Value pair - To delete a key value pair from your table, follow these steps:
      1. Select a key value pair.
      2. Click Delete.
    • Change the Default Value field -  Edit the current setting of the Default Value field. Enter a value in this field, if you want the lookup table to supply a value even when no keys are matched during run time. Leave this field blank, if the lookup table should not return a value when no keys are matched during run time.
    • Change the Value if "nil" value field - Edit the current setting of the Value if "nil" value field. This property only affects nillable nodes. Enter a value in this field, if during run time you want the Lookup table to supply a value even when the source node is empty and the nillable. Leave this field blank, if during run time the lookup table should not return any value when the source node is empty and the source node is nillable.
  6. Click OK.
Lookup tables are added to mapping rules like functions. For more information about adding functions to mapping rules, see Assigning Function(s) to a Mapping Rule.