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 r084

D toc

Excerpt

Returns true if both arguments evaluate 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 AND 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 s lang vs sql
 

D s
snippetBasic

D lang syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive type:single value: and(finalScoreEnglish >= 60, finalScoreMath >=60) as:'promoteStudent'

and(finalScoreEnglish >= 60, finalScoreMath >=60)

Output: Returns true if the values in the finalScoreEnglish and finalScoreMath columns are greater than or equal to 60. Otherwise, the value is false

D s
snippetSyntax

D lang syntax
RawWrangletrue
Typesyntax
showNotetrue
WrangleTextderive type:single value:and(value1, value2)

and(value1, value2)


ArgumentRequired?Data TypeDescription
value1YstringThe first value must be a Boolean literal, column reference, or expression that evaluates to true or false.
value2YstringThe first value must be a Boolean literal, column reference, or expression that evaluates to true or false.

D s lang notes

value1, value2

Expressions, column references or literals to compare as Boolean values.

  • Missing or mismatched values generate missing results.

D s
snippetusage

Required?Data TypeExample Value
YesFunction or column reference returning a Boolean value or Boolean literalmyHeight > 2.00


D s
snippetExamples

Example - Logical Functions

Include Page
EXAMPLE - Logical Functions
EXAMPLE - Logical Functions

D s also
labellogical