Page tree



Contents:

The cloud-based version of Trifacta Wrangler is now available! Read all about it, and register for your free account.

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.

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

ceiling(numeric_value)


ArgumentRequired?Data TypeDescription
numeric_valueYstring, decimal, or integerName 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 TypeExample Value
YesString (column reference) or Integer or Decimal literal2.5

Examples

Example - Exponential functions

The following example demonstrates how the rounding functions work together. These functions include the following:

  • FLOOR - largest integer that is not greater than the input value. See FLOOR Function.
  • CEILING - smallest integer that is not less than the input value. See CEILING Function.
  • ROUND - nearest integer to the input value. See ROUND Function.
  • MOD - remainder integer when input1 is divided by input2. See Numeric Operators

Source:

rowNumX
1-2.5
2-1.2
30
41
51.5
62.5
73.9
84
94.1
1011

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:

rowNumXmodXroundXceilingXfloorX
1-2.5 -2-2-3
2-1.2 -1-1-2
300000
411111
51.5 221
62.5 332
73.9 443
840444
94.1 454
10111111111

Your Rating: Results: 1 Star2 Star3 Star4 Star5 Star 12 rates

This page has no comments.