| Excerpt |
|---|
Returns true if the argument is an even value. Argument can be an Integer, a function returning Integers, or a column reference. |
Since the function returns a Boolean value, it can be used as a function or a conditional.
Integer literal value:
| D code |
|---|
derive type:single value: ISEVEN('4') as: 'isFourEven' |
Output: Generates the
isFourEven column containing the value
true for each row.
Column reference value:
| D code |
|---|
delete row: (ISEVEN(errorCount)) |
Output: If the value in the errorCount column is an even number, then delete the row.
| D code |
|---|
derive type:single value:ISEVEN(int_value) |
| Argument | Required? | Data Type | Description |
|---|
| int_value | Y | integer | This value can be an Integer, a function returning an Integer, or a column reference. |
int_value
Name of the columns, expressions, or literals to compare.
- Missing values generate missing string results.
| Required? | Data Type | Example Value |
|---|
| Yes | Column reference, function, or Integer literal value | myColumn |
Example - Basic Equal and Notequal Functions
| Include Page |
|---|
| EXAMPLE - Comparison Functions Equal |
|---|
| EXAMPLE - Comparison Functions Equal |
|---|
|
