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.

- 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.

- This node has no views

- 0_MS-DIAL_MS-Finder_v6_JSSX 1v1KNIME Hub
- 00_Guided_Labeling_for_Document_Classification_(legacy)KNIME Hub
- 01_Compute_LIMEsKNIME Hub
- 01_Compute_LIMEsKNIME Hub
- 01_Geo_Distance_Calculation_using_GeoPy_packageKNIME Hub
- Show all 343 workflows

- Rule Based row filter - not getting the filter requestedby HansS on 2020-02-21forum.knime.com/p/82306
- Number to Stringby ipazin on 2023-01-13forum.knime.com/p/188932

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:

v4.7

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