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.
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.
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:
A zipped version of the software site can be downloaded here.
Do you have feedback, questions, comments about NodePit, want to support this platform, or want your own nodes or workflows listed here as well? Do you think, the search results could be improved or something is missing? Then please get in touch! Alternatively, you can send us an email to mail@nodepit.com, follow @NodePit on Twitter, or chat on Gitter!
Please note that this is only about NodePit. We do not provide general support for KNIME — please use the KNIME forums instead.