Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r097

D toc

Excerpt

Returns true if the argument is an odd 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 lang vs sql

D s
snippetBasic

Integer literal value:

D lang syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive type:single value: isodd('3') as: 'isThreeOdd'

isodd('3')

Output: Returns the value true.

Column reference value:

D lang syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive type:single value: (isodd(countStudents)) as:'missingStudent'

isodd(countStudents)

Output: If the value in the countStudents column is an odd number, then return true

D s
snippetSyntax

D lang syntax
RawWrangletrue
Typesyntax
showNotetrue
WrangleTextderive type:single value:isodd(int_value)

isodd(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

int_value

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

  • Missing values generate missing string results.

D s
snippetusage

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

D s
snippetExamples

Example - Basic Equal and Notequal Functions

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

D s also
labelcomparison