| 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 lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | ref |
|---|
| showNote | true |
|---|
| WrangleText | derive 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 lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | syntax |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value:and(value1, value2) |
|---|
|
and(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 |
|---|
|
