A powerful Data transformation language similar to Pascal is included in all our ETL and Business automation tools.
It can be used with Calculation Transformation Function, Package Script Action or inside any text object
Sqr(X)
the Sqr function returns the square of the argument. X is a floating-point expression. The result, of the same type as X, is the square of X, or X*X.
Sqrt(X)
The result is the square root of X.
Exp(X)
Exp returns the value of e raised to the power of X, where e is the base of the natural logarithms
Ln(X)
Ln returns the natural logarithm (Ln(e) = 1) of the real-type expression X.
Sin(X)
Sin returns the sine of the angle X in radians.
Cos(X)
Cos returns the cosine of the angle X. X expression that represents an angle in radians
Tan(X)
Tan returns the tangent of X. Tan(X) = Sin(X) / Cos(X).
ArcTan(X)
ArcTan returns the arctangent of X. X is a real-type expression that gives an angle in radians
PI
Represents the mathematical value pi, the ratio of a circle's circumference to its diameter. Pi is approximated as 3.1415926535897932385.
ArcCos(X)
ArcCos returns the inverse cosine of X. X must be between -1 and 1. The return value is in the range [0..Pi], in radians.
ArcCosh(X)
ArcCosh returns the inverse hyperbolic cosine of X. The value of X must be greater than or equal to 1.
ArcCot(X)
ArcCot returns the inverse cotangent of X.
ArcCotH(X)
ArcCot returns the inverse hyperbolic cotangent of X.
ArcCsc(X)
ArcCsc returns the inverse cosecant of X.
ArcCscH(X)
ArcCsc returns the inverse hyperbolic cosecant of X.
ArcSec(X)
ArcSec returns the inverse secant of X.
ArcSecH(X)
ArcSec returns the inverse hyperbolic secant of X.
ArcSin(X)
ArcSin returns the inverse sine of X. X must be between -1 and 1. The return value will be in the range [-Pi/2..Pi/2], in radians.
ArcSinh(X)
ArcSinh returns the inverse hyperbolic sine of X.
ArcTan(X)
ArcTan returns the arctangent of X. X is a real-type expression that gives an angle in radians.
ArcTanh(X)
ArcTanh returns the inverse hyperbolic tangent of X. The value of X must be between -1 and 1 (inclusive).
Cosecant(X)
Use the Cosecant to calculate the cosecant of X, where X is an angle in radians. The cosecant is calculated as 1/ Sin(X).
Cosh(X)
Use the Cosh to calculate the hyperbolic cosine of X.
Cot(X)
Call Cot to obtain the cotangent of X. The cotangent is calculated using the formula 1 / Tan (X).
Cotan(X)
Call Cotan to obtain the cotangent of X. The cotangent is calculated using the formula 1 / Tan (X)
Do not call Cotan with X = 0
CotH(X)
Call CotH to obtain the hyperbolic cotangent of X, where X is an angle in Radians.
Csc(X)
Use the Csc to calculate the cosecant of X, where X is an angle in radians.
CscH(X)
Use the CscH to calculate the hyperbolic cosecant of X, where X is an angle in radians.
CycleToDeg(X)
CycleToDeg converts angles measured in cycles into degrees, where degrees = cycles * 360.
CycleToGrad(X)
CycleToGrad converts angles measured in cycles into grads.
CycleToRad(X)
CycleToRad converts angles measured in cycles into radians, where radians = 2pi * cycles.
DegToCycle(X)
Use DegToCycle to convert angles expressed in degrees to the corresponding value in cycles.
DegToGrad(X)
Use DegToGrad to convert angles expressed in degrees to the corresponding value in grads.
DegToRad(X)
Use DegToRad to convert angles expressed in degrees to the corresponding value in radians, where radians = degrees(pi/180).
GradToCycle(X)
GradToCycle converts angles measured in grads into cycles.
GradToDeg(X)
GradToDeg converts angles measured in grads into degrees.
GradToRad(X)
GradToRad converts angles measured in grads into radians, where radians = grads(pi/200).
Hypot(X,Y)
Hypot returns the length of the hypotenuse of a right triangle. Specify the lengths of the sides adjacent to the right angle in X and Y. Hypot uses the formula Sqrt(X**2 + Y**2)
IntPower(Base,Exponent)
IntPower raises Base to the power specified by Exponent.
Ldexp(X)
Ldexp returns X times (2 to the power of P).
LnXP1(X)
LnXP1 returns the natural logarithm of (X+1). Use LnXP1 when X is a value near 0.
Log10(X)
Log10 returns the log base 10 of X.
Log2(X)
Log2 returns the log base 2 of X.
LogN(Base,X)
LogN returns the log base Base of X.
Power(Base,Exponent)
Power raises Base to any power. For fractional exponents or exponents greater than MaxInt, Base must be greater than 0.
RadToCycle(X)
Use RadToCycle to convert angles measured in radians into cycles, where cycles = radians/(2pi).
RadToDeg(X)
Use RadToDeg to convert angles measured in radians to degrees, where degrees = radians(180/pi).
RadToGrad(X)
Use RadToGrad to convert angles measured in radians to grads, where grads = radians(200/pi).
RandG(Mean,StdDev)
RandG produces random numbers with Gaussian distribution about the Mean. This is useful for simulating data with sampling errors and expected deviations from the Mean.
Sec(X)
Call Sec to obtain the secant of X, where X is an angle in radians. The secant is calculated using the formula 1 / Cos(X).
SecH(X)
Call SecH to obtain the hyperbolic secant of X, where X is an angle in Radians.
Sinh(X)
Sinh calculates the hyperbolic sine of X.
Tan(X)
Tan returns the tangent of X. Tan(X) = Sin(X) / Cos(X).
Tanh(X)
Tanh calculates the hyperbolic tangent of X.
