StreamableKNIME Base Nodes version 3.6.0.v201807061308 by KNIME AG, Zurich, Switzerland
Rounds double values to the specified decimal place or significant
figures, applying the specified rounding method. The columns
containing the double values can be specified. The rounded values
can be appended as additional columns, or the old values are
replaced by the rounded values. If rounded values are appended as
additional columns, a column suffix for the columns to append needs
to be specified.
To round the values seven different rounding modes are available: UP, DOWN, CEILING, FLOOR, HALF_UP, HALF_DOWN, HALF_EVEN. For the detailed description of each rounding mode please see the Java documentation.
The output formatting can be of different types, which are described by example below. Rounding the numbers 1.23501, 0.00000035239 and -3.123103E9 to 3 significant digits (HALF_UP) will produce:
|Input||Double(*)||Standard String||Plain String (no exponent)||Engineering String|
(*)Note that the "Double" output option may yield unexpected results due to numerical precision issue when representing floating point numbers. For example a number such as 0.1 can sometimes be represented as 0.09999999999999999.
To use this node in KNIME, install KNIME Base Nodes from the following update site: