Identifying Data Values that Contain Key Words or Character Strings
To find a word or a character string in a column of input data, configure a condition to use the "contains" operator. You might use the operator to find a single data value when each field in the input contains multiple values. Or, you might use the operator to find input data values that contain a character string within a longer string.
For example, you might work for an organization that stores inventory items in a warehouse. The organization must manage the warehouse space and ensure that inventory items stay in the warehouse for as little time as possible. You want to measure the number of items in inventory for a range of products. You configure a single condition to identify the products in a product table. The product names are West Wood, West Star, and West Land. You design a condition to find product names that contain the string "West."
The rule statement that you configure might represent a single element in a business rule. For example, the business rule might describe a policy to reduce the sale price of products that spend a long time in inventory. The current rule statement generates an output that a rule statement in a parent rule set can read as an input.
1. Select a rule set in a rule specification.
2. In the rule set properties, click Rule Logic.
3. Click Add Rule Statement.
4. Select an input for the rule statement.
- - If the rule specification does not contain an input that you can use, create an input. Configure the input properties to represent the type of column that contains the business data.
5. Select an operator to validate the results of the condition analysis.
- - To specify that the input data must match the data that you enter, select the following operator:
contains
6. Select the type of condition to apply to the input.
- - To compare the input data to a string value, select the following condition type:
string value
7. Enter the value to compare to the input data. For example, enter "West."
The condition searches the rule statement input for the string value that you enter.
Note: You can also compare the rule statement input to a value in another input column on the same row. When you specify an input column as the condition type, the condition looks for the condition input data in the rule statement input data.
8. Select the type of action to apply to the data that satisfies the condition logic. For example, you might configure an action that returns the inventory numbers for each product.
- - To return the data values from another column on the same row, select the following action type:
input
9. Select the input that represents the inventory level for each product in the warehouse.
10. Save the rule specification.