Icon

Smart Rounding Example

The solution to a question raised in the KNIME Forum:
"I have to translate the SmartRound function (Returns (x) rounded to the nearest multiple of a value determined dynamically based on the size of (x).) from Alteryx to KNIME."

This will workflow implements the solution...

SmartRound in KNIME Raised in a forum post: "I have to translate the SmartRound function (Returns (x) rounded to the nearest multiple of avalue determined dynamically based on the size of (x).) from Alteryx to KNIME."This workflow will replicate the exact same behavior. It's multiplying the input value times 4, thenapplying rounding by 4 significant digets, then divided by result by 4 again.https://forum.knime.com/t/smartround-in-knime/41629 Table Creator Round Double Math Formula Math Formula SmartRound in KNIME Raised in a forum post: "I have to translate the SmartRound function (Returns (x) rounded to the nearest multiple of avalue determined dynamically based on the size of (x).) from Alteryx to KNIME."This workflow will replicate the exact same behavior. It's multiplying the input value times 4, thenapplying rounding by 4 significant digets, then divided by result by 4 again.https://forum.knime.com/t/smartround-in-knime/41629 Table Creator Round Double Math Formula Math Formula

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: wiswedel
Created at: 2022-05-09
On NodePit since: 2022-05-09
Last update: 2024-05-02
Created with KNIME version: v4.5.2

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!