Defining Lookup Tables

About this task

To define or create a 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. To display the Lookup Table dialog box, choose from one of the following options:
    • Right-click the Lookup Tables node in the Functions tab and from the menu select Add New Lookup Table... .
    • In the Actions pane, select Add New Lookup Table.
    The Lookup Table dialog box opens.
  3. In the Table Name field of the Lookup Table dialog box, enter a name for your lookup table.
    Note: This name must be unique for all tables in the current project. The name of the table is not case sensitive - the case of a character is not considered. For example, the table name: Aaa is equivalent to the table name: AAA.
  4. Optional: In the Description field enter descriptive information about the table.
  5. Define the Key Value pairs for the table.
    Repeat the following steps for each Key Value pair in the table:
    1. Click Add.
    2. In the Key field, enter the value of the key. During run time, this key will be matched 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.
  6. Optional: Enter a value in 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.
  7. Optional: Enter a value in the Value if "nil" 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 source node is 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.
  8. Click OK.



Feedback | Notices


Timestamp icon Last updated: Thursday, December 17, 2015


http://pic.dhe.ibm.com/infocenter/wci/v7r0m0/topic/com.ibm.wci.doc/defining_lookup_tables.html