| Excerpt |
|---|
Returns true if the first argument is less than but not equal to the second argument. Equivalent to the < operator. |
- Each argument can be a literal Integer or Decimal number, a function returning a number, or a reference to a column containing numbers.
Since the 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 Comparison Operators. |
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | ref |
|---|
| showNote | true |
|---|
| WrangleText | keep row: lessthan(Errors, 10) |
|---|
|
lessthan(Errors, 10) |
Output: Returns true when the value in the Errors column is less than 10.
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | syntax |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value:lessthan(value1, value2) |
|---|
|
lessthan(value1, value2) |
| Argument | Required? | Data Type | Description |
|---|
| value1 | Y | string | The first value. This can be a number, a function returning a number, or a column containing numbers. |
| value2 | Y | string | The second value. This can be a number, a function returning a number, or a column containing numbers. |
value1, value2
Names of the column, expressions, or literals to compare.
- Missing values generate missing string results.
| Required? | Data Type | Example Value |
|---|
| Yes | Column reference, function, or numeric or String value | myColumn |
Example - Basic Comparison Functions
| Include Page |
|---|
| EXAMPLE - Comparison Functions1 |
|---|
| EXAMPLE - Comparison Functions1 |
|---|
|
Example - Using Comparisons to Test Ranges
| Include Page |
|---|
| EXAMPLE - Comparison Functions2 |
|---|
| EXAMPLE - Comparison Functions2 |
|---|
|
