The Condition option on the Element menu allows you to attach a condition to an element that controls whether or not the element is mapped. On the Condition window, specify which record fields or memory variables are to be checked against what other record fields, memory variables, or constants before mapping the element.
If one or more of the conditions is dependent upon the value of data in another element, you must make that other element a conditional variable. For more information about conditional variables, see “Mapping to a conditional variable”.
You can set up one or two conditions. If you set up two conditions, both must be true for the mapping to occur. This is the equivalent of linking the two conditions with a Boolean AND.
Attaching a condition to an element
Do one of the following:
Highlight the element and choose Element>Condition.
Right-click the element and choose Condition from the drop-down list.
The Element Conditions window displays.
Select the top the up arrow to choose the type of data to be evaluated in the condition. Choices are:
Record/Field to select field from the Records/Tables window. The program enters the record and field names into the top text boxes.
Memory Variable to select a memory variable from the Memory Variables window. The program enters MEMVAR into the top text box and the name of the memory variable into the next text box.
Clear Condition to remove the information entered in the condition.
Select the middle up arrow to choose the operator to be used in the condition. Choices are:
EQ – equal to
NE – not equal to
LT – less than
LE – less than or equal to
GT – greater than
GE – greater than or equal to
Under Condition 1 (or 2), select the bottom up arrow to choose the type of data against which the data in the condition is evaluated. If you choose:
Record/Field to select field from the Records/Tables window. The program enters the record and field names into the bottom text boxes.
Memory Variable to select a memory variable from the Memory Variables window. The program enters MEMVAR into the bottom text box and the name of the memory variable into the next text box.
Constant – the Constant window displays. Enter the constant value in the Constant text box.
Select OK, and the program enters STRVAR and the constant value into the bottom two text boxes.