Math FX

The Math FX node is used to create a new column based on a mathematical function applied to a given numeric column. This function supports the following numeric column types: Integer, Float 32, Float 64, and BigInteger.

  • Click here to learn more about mathematical functions.

Configure Math FX

Connect the Math FX node to the Select tables of the relevant table. Go to the Properties panel and set the preferences for the mathematical function:

Select Column: choose the column to which the mathematical function will be applied.

Function Type: choose the mathematical function to apply to the column.

Column Output: determine whether or not to keep the original column.

New Column Name: name the new column.

Function Type

The Math FX node enables the following mathematical functions:

  • Absolute Value: returns the absolute value of a number.
  • Ceiling: returns the smallest integer greater than or equal to a given number.
  • Floor: returns the largest integer less than or equal to a given number.
  • Exponent: returns the number 'e' or Euler's number, raised to the power of the provided value.
  • Log: returns the natural logarithm (base e) of a number.
  • Power: returns the base number to the exponent power.
  • Root:
  • Round: returns the value of a number rounded to the nearest integer.