Page tree



Contents:

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

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.