Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

D toc

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.

D s

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 s

D code

derive type:single value:ISEVEN(int_value)

ArgumentRequired?Data TypeDescription
int_valueYintegerThis value can be an Integer, a function returning an Integer, or a column reference.

D s lang notes


Name of the columns, expressions, or literals to compare.

  • Missing values generate missing string results.

D s

Required?Data TypeExample Value
YesColumn reference, function, or Integer literal valuemyColumn

D s

Example - Basic Equal and Notequal Functions

Include Page
EXAMPLE - Comparison Functions Equal
EXAMPLE - Comparison Functions Equal

D s also