Setting Derive State Options

Derive State nodes are somewhat similar to Derive Flag nodes. A Flag node sets values depending on the fulfillment of a single condition for the current record, but a Derive State node can change the values of a field depending on how it fulfills two independent conditions. This means that the value will change (turn on or off) as each condition is met.

Initial state. Select whether to give each record of the new field the On or Off value initially. Note that this value can change as each condition is met.

"On" value. Specify the value for the new field when the On condition is met.

Switch "On" when. Specify a CLEM condition that will change the state to On when the condition is true. Click the calculator button to open the Expression Builder.

"Off" value. Specify the value for the new field when the Off condition is met.

Switch "Off" when. Specify a CLEM condition that will change the state to Off when the condition is false. Click the calculator button to open the Expression Builder.

Note: To specify an empty string, you should type opening and closing quotes with nothing between them, such as "". Similarly, quotes should be used if you want a string value that would otherwise be treated as a number.