Rule Specification Guide

10.2.1
- 10.5.9
- 10.5.6
- 10.5.4
- 10.5
- 10.4.0
- 10.2.2

Back Next

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.

Select a rule set in a rule specification.

In the rule set properties, click

Rule Logic

Click

Add Rule Statement

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.

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

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

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.

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.

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

Select the input that represents the inventory level for each product in the warehouse.

Rename Saved Search

Table of Contents

Rule Specification Guide

Rule Specification Guide

Identifying Data Values that Contain Key Words or Character Strings

Identifying Data Values that Contain Key Words or Character Strings