Sign in
< Back to User Guide Top

Creating and Defining Code Tables

Creating

Create a code table to make a look-up table that validates input data and converts it to an output string or behavior value.

  1. Select File | New | Code Table from the main menu. The New Code Table window appears.
  2. Select either Single Input Code Table or Double Input Code Table and click Next.
  3. Provide the Source folder, Package, and Name.
  4. Click Finish. An editor appears.
    You can also use the Wizard to create this object. Click New  to select the object.

Defining

To define this object, you specify a default value, indicate if the input keys are case-sensitive, and create and assign table entries. For Double Input Code Tables, the comparison type must also be selected.

The following steps take place in the Code Table editor, which has these sections: Settings and Table Entries. Clarify tests the value supplied to the Key 2 parameter against the indicated operator.
  1. Select a Comparison Type (for double input only). Choices are Equal To, Greater Than, Greater Than Or Equal To, Less Than, and Less Than Or Equal To. By design, all Single InputCode Tables are Equal To.
  2. For both Single Input and Double Input Code Tables, specify the Default Value to instruct Clarify how to proceed when it cannot locate the input key(s). Choices are Key for Single Input Code Tables, Key1 and Key2 for Double Input Code Tables, a user-defined string (such as “Not Found”), ReturnNull and ThrowError.
  3. Under the Table Entries section, click the Add button to add a row, and then enter the key(s) and corresponding value. Note that a Value may be either a string or any of the available value/behavior choices: Key for Single Input Code Tables, Key1 and Key2 for Double Input Code Tables, a user-defined string (such as “Not Found”), ReturnNull, and ThrowError.
  4. Click Save to complete task.
Next: Once correctly defined and saved in Clarify, use this object in either a Business Process (as a Task) or a Ruleset (as an Action) to reference the Code Table.

Related articles

Comments

0 comments

Please sign in to leave a comment.