Contents:
Computes the ceiling of a value, which is the smallest integer that is greater than the input value. Input can be an Integer, a Decimal, a column reference, or an expression.
Wrangle vs. SQL: This function is part of Wrangle, a proprietary data transformation language. Wrangle is not SQL. For more information, see Wrangle Language.
Basic Usage
Numeric literal example:
ceiling(2.5)
Output: Generates 3.
Expression example:
ceiling(MyValue + 2.5)
Output: Returns the smallest integer that is greater than the sum of 2.5 and the value in the MyValue column.
Syntax and Arguments
ceiling(numeric_value)
| Argument | Required? | Data Type | Description |
|---|---|---|---|
| numeric_value | Y | string, decimal, or integer | Name of column or Decimal or Integer literal to apply to the function |
For more information on syntax standards, see Language Documentation Syntax Notes.
numeric_value
Name of the column, numeric literal, or numeric expression.
- Missing input values generate missing results.
- Literal numeric values should not be quoted. Quoted values are treated as strings.
- Multiple columns and wildcards are not supported.
Usage Notes:
| Required? | Data Type | Example Value |
|---|---|---|
| Yes | String (column reference) or Integer or Decimal literal | 2.5 |
Tip: For additional examples, see Common Tasks.
Examples
Example - Exponential functions
Functions:
| Item | Description |
|---|---|
| FLOOR Function | Computes the largest integer that is not more than the input value. Input can be an Integer, a Decimal, a column reference, or an expression. |
| CEILING Function | Computes the ceiling of a value, which is the smallest integer that is greater than the input value. Input can be an Integer, a Decimal, a column reference, or an expression. |
| ROUND Function | Rounds input value to the nearest integer. Input can be an Integer, a Decimal, a column reference, or an expression. Optional second argument can be used to specify the number of digits to which to round. |
| MOD Function |
Returns the modulo value, which is the remainder of dividing the first argument by the second argument. Equivalent to the % operator.
|
Source:
| rowNum | X |
|---|---|
| 1 | -2.5 |
| 2 | -1.2 |
| 3 | 0 |
| 4 | 1 |
| 5 | 1.5 |
| 6 | 2.5 |
| 7 | 3.9 |
| 8 | 4 |
| 9 | 4.1 |
| 10 | 11 |
Transformation:
| Transformation Name | New formula |
|---|---|
| Parameter: Formula type | Single row formula |
| Parameter: Formula | FLOOR(X) |
| Parameter: New column name | 'floorX' |
| Transformation Name | New formula |
|---|---|
| Parameter: Formula type | Single row formula |
| Parameter: Formula | CEILING(X) |
| Parameter: New column name | 'ceilingX' |
| Transformation Name | New formula |
|---|---|
| Parameter: Formula type | Single row formula |
| Parameter: Formula | ROUND (X) |
| Parameter: New column name | 'roundX' |
| Transformation Name | New formula |
|---|---|
| Parameter: Formula type | Single row formula |
| Parameter: Formula | (X % 2) |
| Parameter: New column name | 'modX' |
Results:
| rowNum | X | modX | roundX | ceilingX | floorX |
|---|---|---|---|---|---|
| 1 | -2.5 | -2 | -2 | -3 | |
| 2 | -1.2 | -1 | -1 | -2 | |
| 3 | 0 | 0 | 0 | 0 | 0 |
| 4 | 1 | 1 | 1 | 1 | 1 |
| 5 | 1.5 | 2 | 2 | 1 | |
| 6 | 2.5 | 3 | 3 | 2 | |
| 7 | 3.9 | 4 | 4 | 3 | |
| 8 | 4 | 0 | 4 | 4 | 4 |
| 9 | 4.1 | 4 | 5 | 4 | |
| 10 | 11 | 1 | 11 | 11 | 11 |
This page has no comments.