Numeric functions - Cloud

Talend Data Shaping Language Reference Guide

Version
Cloud
Language
English (United States)
Product
Talend Cloud
Module
Data Shaping Language
Content
Design and Development

The following functions can be used to perform operations on numeric values.

Note: The functions exp, ln, log, max and min are only available in Talend Cloud Pipeline Designer.
Function Description Arguments Example
abs Returns the absolute value of a number. Numeric value. Expression: abs(-3)

Result: 3

ceil Returns the smallest integer greater than the input value. If the input value is an integer, the result is the same as the input. Numeric value. Expression: ceil(5.1)

Result: 6.0

exp Returns the constant e to the power of the first argument. Numeric value. Expression: exp(2)

Result: 7.38905609893065

floor Returns the largest integer smaller than the input value. If the input value is an integer, the result is the same as the input. Numeric value. Expression: floor(42.9)

Result: 42.0

ln Returns the logarithm of the first argument to the base of the constant e. Numeric value. Expression: ln(15)

Result: 2.70805020110221

log Returns the logarithm of the first argument to the base of 10. Numeric value. Expression: log(25)

Result: 1.3979400086720377

min Returns the smallest of two numeric values.
  1. First numeric value.
  2. Second numeric value.
Expression: min(1.5, 60)

Result: 1.5

max Returns the largest of two numeric values.
  1. First numeric value.
  2. Second numeric value.
Expression: max(1752,687)

Result: 1752

power Returns the first argument to the power of the second argument.
  1. Numeric value to multiply.
  2. Numeric value to use as exponent.
Expression: power(5,3)

Result: 125.0

round Returns the integer closest to the input value. Numeric value. Expression: round(45.6)

Result: 46

sign Returns 1.0 if the input value is a positive number and -1.0 if the input is a negative number. Numeric value. Expression: sign(15)

Result: 1.0

sqrt Returns the square root of the argument. Numeric value. Expression: sqrt(25)

Result: 5.0