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 largest integer that is not more than the input value. Input can be an Integer, a Decimal, a column reference, or an expression. 

Basic Usage

Numeric literal example:

Output: Returns the value 2.

Expression example:

Output: Returns the largest integer that is less than the sum of 2.5 and the value in the MyValue column.

Syntax


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 11 rates

This page has no comments.