Round Double

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
1.23501	1.24	"1.24"	"1.24"	"1.24"
0.00000035239	0.000000352	"3.52E-7"	"0.000000352"	"352E-9"
-3123103001	-3120000000	"-3.12E+9"	"-3120000000"	"-3.12E+9"

(*)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.

Options

Column selection

The columns containing double values to round.

Append as new columns (specify suffix)

If checked the rounded values will be appended as additional columns. For each selected column one additional column containing the rounded values will be appended. If not checked, the input double values will be replaced by the rounded values. The names of the new columns are those of the original columns with the specified suffix appended.

Output format

Specify the output format here. See table above.

Precision

The scale of the double values to round to. If the scale is reduced the specified rounding mode is applied.

Precision mode

The type of precision to which the values are rounded. Decimal places, the default option rounds to the specified decimal places, whereas significant figures rounds to significant figures or numbers.

Rounding mode

The rounding mode which is applied when double values are rounded. The rounding mode specifies the rounding behavior. Seven different rounding modes are available:

UP: Rounding mode to round away from zero.
DOWN: Rounding mode to round towards zero.
CEILING: Rounding mode to round towards positive infinity.
FLOOR: Rounding mode to round towards negative infinity.
HALF_UP: Rounding mode to round towards "nearest neighbor" unless both neighbors are equidistant, in which case round up.
HALF_DOWN: Rounding mode to round towards "nearest neighbor" unless both neighbors are equidistant, in which case round down.
HALF_EVEN: Rounding mode to round towards the "nearest neighbor" unless both neighbors are equidistant, in which case, round towards the even neighbor.

For a detailed description of each rounding mode please see the Java documentation.

Input Ports

: The input table containing double values to convert.

Output Ports

: The output table containing the rounded double values.

Popular Predecessors

Popular Successors

Views

This node has no views

Workflows

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.

Installation

To use this node in KNIME, install the extension KNIME Base nodes from the below update site following our NodePit Product and Node Installation Guide:

v4.7

A zipped version of the software site can be downloaded here.

Plugin provider: KNIME AG, Zurich, Switzerland

Plugin version: 4.7.0.v202211291414

On NodePit since: 2022-12-06

Last update: 2023-05-28

Tags: Streamable

KNIME versions: Since v3.6