...
| Info |
|---|
NOTE: Within an expression, you might choose to use the corresponding operator, instead of this function. For more information, see Logical Operators. |
| d-code-lang-syntax |
|---|
| RawWrangle | true |
|---|
| Type | ref |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value: |
|---|
| AND| and(finalScoreEnglish >= 60, finalScoreMath >=60) as:'promoteStudent' |
|
and(finalScoreEnglish >= 60, finalScoreMath >=60) |
Output: If the Returns true if the values in the finalScoreEnglish and finalScoreMath columns are greater than or equal to 60, then the value in the new promoteStudent column is true. Otherwise, the value is false.
| d-codelang-syntax |
|---|
| RawWrangle | true |
|---|
| Type | syntax |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value: |
|---|
| AND |
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. |
...
