| Excerpt |
|---|
Returns true if either argument evaluates to true. Equivalent to the || operator. |
- Each argument can be a literal Boolean, a function returning a Boolean, or a reference to a column containing Boolean values.
Since the function returns a Boolean value, it can be used as a function or a conditional.
| Info |
|---|
NOTE: Within an expression, you might choose to use the corresponding operator, instead of this function. For more information, see Logical Operators. |
| D code |
|---|
derive type:single value: OR(daysBillOverdue > 90, violationsCount > 2) as:'cancelAccount' |
Output: If the value in the daysBillOverdue column is greater than 90 and the value in violationsCount column is greater than 2, then the value in the new cancelAccount column is true. Otherwise, the value is false.
| D code |
|---|
derive type:single value:OR(value1, value2) |
| Argument | Required? | Data Type | Description |
|---|
| value1 | Y | string | The first value must be a Boolean literal, column reference, or expression that evaluates to true or false. |
| value2 | Y | string | The first value must be a Boolean literal, column reference, or expression that evaluates to true or false. |
value1, value2
Expressions, column references or literals to compare as Boolean values.
- Missing or mismatched values generate missing results.
| Required? | Data Type | Example Value |
|---|
| Yes | Function or column reference returning a Boolean value or Boolean literal | myHeight > 2.00 |
Example - Logical Functions
| Include Page |
|---|
| EXAMPLE - Logical Functions |
|---|
| EXAMPLE - Logical Functions |
|---|
|
