Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • Nodes
  • Round Double
NodeNode / Manipulator

Round Double

Manipulation Column Convert & Replace Streamable
Drag & drop
Like
Copy short link

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.

Node details

Input ports
  1. Type: Table
    Table containing double values
    The input table containing double values to convert.
Output ports
  1. Type: Table
    Table containing rounded double values
    The output table containing the rounded double values.

Extension

The Round Double node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    Smart Rounding Example
    The solution to a question raised in the KNIME Forum: "I have to translate the SmartRound…
    wiswedel > Public > Forum Questions > 2022 > Smart Rounding Example
    wiswedel
  2. Go to item
    Visualization
    Visualization Composite view Component
    +4
    "Visualization" exercise for basic Life Science User Training - Create an interactive com…
    knime > Education > Courses > L1-LS KNIME Analytics Platform for Data Scientists - Life Sciences - Basics > Exercises > 03. Visualization
    knime
  3. Go to item
    Visualization
    Visualization Composite view Component
    +4
    "Visualization" exercise for basic Life Science User Training - Create an interactive com…
    janina > Customized Training > Customized Training - Life Sciences > Exercises > 03. Visualization
    janina
  4. Go to item
    Visualization
    Visualization Composite view Component
    +4
    "Visualization" exercise for basic Life Science User Training - Create an interactive com…
    pau22nanda > Public > L1-LS KNIME Analytics Platform for Data Scientists - Life Sciences - Basics > Exercises > 03. Visualization
    pau22nanda
  5. Go to item
    Visualization
    Visualization Composite view Component
    +4
    "Visualization" exercise for basic Life Science User Training - Create an interactive com…
    ciaccindr > Public > Corso2022 > L1-LS > Exercises > 03. Visualization
    ciaccindr
  6. Go to item
    Visualization
    Visualization Composite view Component
    +4
    "Visualization" exercise for basic Life Science User Training - Create an interactive com…
    ioneliad > Public > ID_Workflow_Group > L1-LS KNIME Analytics Platform for Data Scientists - Life Sciences - Basics > Exercises > 03. Visualization
    ioneliad
  7. Go to item
    Visualization
    Visualization Composite view Component
    +4
    "Visualization" exercise for basic Life Science User Training - Create an interactive com…
    ioneliad > Public > ID_Workflow_Group > L1-DS KNIME Analytics Platform for Data Scientists - Basics > L1-LS KNIME Analytics Platform for Data Scientists - Life Sciences - Basics > Exercises > 03. Visualization
    ioneliad
  8. Go to item
    Relations in data with scatter and bubble plots
    Visualization Relation Relationship
    +7
    This exercise focuses on learning about the relations among the data of prices of the hou…
    barbora > Courses > L4-DV Codeless Data Exploration and Visualization_10.2020 > L4-DV Codeless Data Exploration and Visualization - Exercises > solutions > 02c. Scatter Plot - solution
    barbora
  9. Go to item
    Relations in data with scatter and bubble plots
    Visualization Relation Relationship
    +7
    This exercise focuses on learning about the relations among the data of prices of the hou…
    barbora > Courses > L4-DV Codeless Data Exploration and Visualization_12.2020 > L4-DV Codeless Data Exploration and Visualization - Exercises > solutions > 02c. Scatter Plot - solution
    barbora
  10. Go to item
    [Community Nodes] CN-133 Bundle Generator Node
    The Bundle Generator node aggregates together one or more new Bundled Products from a sel…
    scientificstrategy > Public > Community Nodes > CN-133 Bundle Generator Node v05
    scientificstrategy
  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. Go to item
  6. Go to item

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Business Hub
© 2023 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits