Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Name
Abs (Real)
Syntax
Abs (Real number)
Purpose
To return the absolute value of a given number.
Description
Returns the absolute value for the given number.
Return Type
Real
Parameters
number [System.Double] – Number for which the absolute value will be returned
Example
In this example, we are passing negative double value to the function transformation object using a Variables object.
Where,
number = -1234
In the output window, you can see that the absolute value, 1234, has been returned for the provided number value.
Name
Abs (Decimal)
Syntax
Abs (Decimal number)
Purpose
To return the absolute value of a given number.
Description
Returns the absolute value for the given number.
Return Type
Decimal
Parameters
number [System.Decimal] – Number for which the absolute value will be returned
Example
In this example, we are passing negative decimal value to the function transformation object using a Variables object.
Where,
number = -1.234
In the output window, you can see that the absolute value, 1.234, has been returned for the provided number value.
Name
Floor (Decimal)
Syntax
Floor (Decimal number)
Purpose
To return the largest integer equal to or less than the number specified.
Description
Rounds to the largest integer equal to or less than the number specified
Return Type
Integer
Parameters
number [System.Decimal] – Number for which the floor value will be returned
Example
In this example, we are passing a decimal value to the function transformation object using a Variables object.
Where,
number = 12.34
In the output window, you can see that the floor value, 12, has been returned for the provided number value.
Name
Floor (Real)
Syntax
Floor (Real number)
Purpose
To return the largest integer equal to or less than the number specified.
Description
Rounds to the largest integer equal to or less than the number specified
Return Type
Integer
Parameters
number [System.Double] – Number for which the floor value will be returned
Example
In this example, we are passing a real value to the function transformation object using a Variables object.
Where,
number = -12.34
In the output window, you can see that the floor value, -13, has been returned for the provided number value.
Name
Max (Decimal)
Syntax
Max (Decimal first, Decimal second)
Purpose
To return the greater of two decimal values.
Description
Returns the maximum of two decimal values.
Return Type
Decimal
Parameters
first [System.Decimal] – First value
second [System.Decimal] – Second value
Example
In this example, we are passing decimal values to the function transformation object using a Variables object.
Note: This function also takes into account negative values.
Where,
first = 1.23
second = 3.21
In the output window, you can see that the greater decimal value has been returned.
Name
Max (Real)
Syntax
Max (Real first, Real second)
Purpose
To return the greater of two real values.
Description
Returns the maximum of two real values.
Return Type
Real
Parameters
first [System.Double] – First value
second [System.Double] – Second value
Example
In this example, we are passing real values to the function transformation object using a Variables object.
Where,
first = -1234
second = 4.321
In the output window, you can see that the greater real value has been returned.
Name
Ceiling (Real)
Syntax
Ceiling (Real number)
Purpose
To return the smallest integer greater than or equal to the number specified.
Description
Returns the smallest integer greater than or equal to the number specified.
Return Type
Integer
Parameters
number [System.Double] – Number for which the ceiling value will be returned
Example
In this example, we are passing a real value to the function transformation object using a Variables object.
Where,
number = -12.34
In the output window, you can see that the ceiling value, -12, has been returned for the provided number value.
Name
Max (Date)
Syntax
Max (Date first, Date second)
Purpose
To return the later of two date values.
Description
Returns the maximum of two date values.
Return Type
DateTime
Prameters
first [System.DateTime] – First value
second [System.DateTime] – Second value
Example
In this example, we are passing DateTime values to the function transformation object using a Variables object.
Where,
first = 09/08/1998
second = 05/04/1995
In the output window, you can see that the later date of the two provided date values has been returned.
Let’s now pass the same date values, but with different time values.
Where,
first = 09/08/1998 02:50:40 AM
second = 09/08/1998 02:50:50 AM
In the output window, you can see that the later datetime of the two provided datetime values has been returned.
Name
Max (Integer)
Syntax
Max (Integer first, Integer second)
Purpose
To return the greater of two integer values.
Description
Returns the maximum of two integer values.
Return Type
Int64
Parameters
first [System.Int64] – First value
second [System.Int64] – Second value
Example
In this example, we are passing integer values to the function transformation object using a Variables object.
Note: This function also takes into account negative values.
Where,
first = 1234
second = 4321
In the output window, you can see that the greater integer value has been returned.
Name
Min (Integer)
Syntax
Min (Integer first, Integer second)
Purpose
To return the smaller of two integer values.
Description
Returns the minimum of two integer values.
Return Type
Int64
Parameters
first [System.Int64] – First value
second [System.Int64] – Second value
Example
In this example, we are passing integer values to the function transformation object using a Variables object.
Where,
first = 1234
second = 4321
In the output window, you can see that the smaller integer value has been returned.
Name
Min (Decimal)
Syntax
Min (Decimal first, Decimal second)
Purpose
To return the smaller of two decimal values.
Description
Returns the minimum of two decimal values.
Return Type
Decimal
Paramaters
first [System.Decimal] – First value
second [System.Decimal] – Second value
Example
In this example, we are passing decimal values to the function transformation object using a Variables object.
Note: This function also takes into account negative values.
Where,
first = 1.23
second = 3.21
In the output window, you can see that the smaller decimal value has been returned.
Name
Pow
Syntax
Pow (Real base, Real exponent)
Purpose
To return base value raised to the power signified by the exponent value.
Description
Returns base raised to power exponent
Return Type
Real
Parameters
base [System.Double] – Base value
exponent [System.Double] – Exponent value
Example
In this example, we are passing base and exponent values to the function transformation object using a Variables object.
Where,
base = 5
exponent = 3
In the Data Preview window, you can see that the returned value, 125, is the base value, 5, raised to the exponent value, 3.
Name
Round (Real-Integer decimals)
Syntax
Round (Real number, Integer decimals)
Purpose
To round a given number to a specified number of decimal places.
Description
Rounds a given number to the specified number of decimal places.
Return Type
Real
Parameters
number [System.Double] – Number for which the rounded value will be returned
decimals [System.Int64]
Example
In this example, we are passing a real value and an integer value (to specify decimal places) to the function transformation object using a Variables object.
Where,
number = -12.3456789
decimals = 3
In the Data Preview window, you can see that a value, rounded to the specified number of decimal places, has been generated.
Name
Round (Decimal-Integer decimals)
Syntax
Round (Decimal number, Integer decimals)
Purpose
To round a given number to a specified number of decimal places.
Description
Rounds a given number to the specified number of decimal places.
Return Type
Real
Parameters
number [System.Decimal] – Number for which the rounded value will be returned
decimals [System.Int64]
Example
In this example, we are passing a decimal value and an integer value (to specify decimal places) to the function transformation object using a Variables object.
Where,
number = 12.3456789
decimals = 3
In the Data Preview window, you can see that a value, truncated to the specified number of decimal places, has been generated.
Name
Min (Date)
Syntax
Min (Date first, Date second)
Purpose
To return the earlier of two date values.
Description
Returns the minimum of two date values.
Return Type
DateTime
Parameters
first [System.DateTime] – First value
second [System.DateTime] – Second value
Example
In this example, we are passing DateTime values to the function transformation object using a Variables object.
Where,
first = 09/08/1998
second = 05/04/1995
In the output window, you can see that the earlier date of the two provided date values has been returned.
Let’s now pass the same date values, but with different time values.
Where,
first = 09/08/1998 02:50:40 AM
second = 09/08/1998 02:50:50 AM
In the output window, you can see that the earlier datetime of the two provided datetime values has been returned.
Name
Round (Real)
Syntax
Round (Real number)
Purpose
To round a given number
Description
Rounds a real number to the nearest integer value.
Return Type
Integer
Parameters
number [System.Double] – Number for which the rounded value will be returned
Example
In this example, we are passing a real value to the function transformation object using a Variables object.
Where,
number = -12.3456
In the Data Preview window, you can see that the specified real value has been rounded to its nearest integer value i.e., -12.
Name
Ceiling (Decimal)
Syntax
Ceiling (Decimal number)
Purpose
To return the smallest integer greater than or equal to the number specified.
Description
Returns the smallest integer greater than or equal to the number specified.
Return Type
Integer
Parameters
number [System.Decimal] – Number for which the ceiling value will be returned
Example
In this example, we are passing a decimal value to the function transformation object using a Variables object.
Where,
number = 12.34
In the output window, you can see that the ceiling value, 13, has been returned for the provided number value.
Name
Min (Real)
Syntax
Min (Real first, Real second)
Purpose
To return the smaller of two real values.
Description
Returns the minimum of two real values.
Return Type
Real
Parameters
first [System.Double] – First value
second [System.Double] – Second value
Example
In this example, we are passing real values to the function transformation object using a Variables object.
Where,
first = -1234
second = 4.321
In the output window, you can see that the smaller real value has been returned.
Name
RandomReal
Syntax
RandomReal (Integer min, Integer max)
Purpose
To generate a random number.
Description
Generates a random number within a range defined by min and max values.
Return Type
Real
Parameters
min [System.Int32] – Minimum number to return
max [System.Int32] – Maximum number to return
Example
In this example, we are passing min and max values to the function transformation object using a Variables object.
Where,
min = 1
max = 5
In the Data Preview window, you can see that a random real value, which falls within the provided min and max values, has been generated.
Name
Round (Decimal)
Syntax
Round (Decimal number)
Purpose
To round a given number
Description
Rounds a decimal to number to the nearest integer value.
Return Type
Integer
Parameters
number [System.Decimal] – Number for which the rounded value will be returned
Example
In this example, we are passing a decimal value to the function transformation object using a Variables object.
Where,
number = 12.345
In the Data Preview window, you can see that the rounded value, 12, has been generated.