Rounds numeric values to the specified decimal place or significant figures, applying a rounding method to selected columns containing numeric values. The rounded values can be appended as additional columns, or replace the values in the original column. You can choose one of the following rounding methods:
- .5 to even digit (HALF_EVEN)
- .5 away from zero (HALF_UP)
- .5 towards zero (HALF_DOWN)
- Away from zero (UP)
- Towards zero (DOWN)
- To larger (CEILING)
- To smaller (FLOOR)
Options
Popular Predecessors
- Math Formula11 %
- GroupBy9 %
- Column Filter6 %
- String to Number5 %
- Joiner4 %
- Column Resorter3 %
Row Filter (deprecated)3 %Column Rename3 %- Concatenate2 %
- Rule-based Row Filter2 %
- Math Formula (Multi Column)2 %
- Rule Engine2 %
- Missing Value2 %
- Excel Reader2 %
- Sorter2 %
- Column Expressions (legacy)1 %
- Number to String1 %
- String Manipulation1 %
- Number Rounder1 %
- Loop End1 %
- Pivot1 %
- Duplicate Row Filter< 1 %
- Java Snippet< 1 %
Concatenate (Optional in)< 1 %- Linear Correlation< 1 %
- DB Query Reader< 1 %
- Date&Time to String< 1 %
Linear Correlation< 1 %Row Splitter (deprecated)< 1 %- String Replacer< 1 %
- Rule-based Row Splitter< 1 %
- String to Date&Time< 1 %
XLS Reader< 1 %- CSV Reader< 1 %
- Table Manipulator< 1 %
- Date&Time Part Extractor< 1 %
- Column Renamer< 1 %
- Constant Value Column< 1 %
Rank Correlation< 1 %- Beta Distributed Assigner< 1 %
- Column Comparator< 1 %
- Random Number Assigner< 1 %
- Weka Predictor (3.7)< 1 %
Python Script (1⇒1)< 1 %- Missing Value Column Filter< 1 %
- Table Creator< 1 %
Regression Predictor< 1 %Cell Splitter< 1 %- Reference Row Filter< 1 %
- Moving Average< 1 %
- Java Snippet Row Splitter< 1 %
Table Reader< 1 %- Column Auto Type Cast< 1 %
- Time Difference (legacy)< 1 %
- Denormalizer< 1 %
Excel Reader (XLS)< 1 %- Date&Time Shift< 1 %
- Cell Splitter< 1 %
- Scorer< 1 %
- Column Merger< 1 %
- Column Rename (Regex)< 1 %
- Counter Generation< 1 %
- Cross Joiner< 1 %
- String to Number (PMML)< 1 %
- DB Reader< 1 %
- Table Reader< 1 %
- Double to Integer< 1 %
Joiner< 1 %- RowID< 1 %
- SDF Reader< 1 %
- Date Field Extractor (legacy)< 1 %
- Reference Column Resorter< 1 %
- Column Appender< 1 %
- Inject Variables (Data)< 1 %
File Reader< 1 %- X-Aggregator< 1 %
- Auto-Binner< 1 %
- Column Splitter< 1 %
- Molecule Type Cast< 1 %
Extract Date&Time Fields< 1 %Variable to Table Column< 1 %- Number to Category (Apply)< 1 %
- Gamma Distributed Assigner< 1 %
- XGBoost Predictor (Regression)< 1 %
- Catch Errors (Data Ports)< 1 %
- Regression Predictor< 1 %
- Simple Regression Tree Predictor< 1 %
- Table View (JavaScript)< 1 %
Variable to Table Row< 1 %- Date&Time-based Row Filter< 1 %
- Value Counter< 1 %
- DB Column Rename< 1 %
- Remove Empty Rows< 1 %
- Pie Chart< 1 %
CSV Reader< 1 %Database Looping< 1 %- MultiLayerPerceptron Predictor< 1 %
- Normalizer< 1 %
- Row Sampling< 1 %
- Ungroup< 1 %
CASE Switch Data (Start)< 1 %- Data Generator< 1 %
- Random Number Assigner (Apache)< 1 %
- Date&Time Difference< 1 %
- Random Numbers Generator< 1 %
- Logistic Regression Predictor< 1 %
- Column Combiner< 1 %
- Nominal Value Row Splitter< 1 %
- Numeric Row Splitter< 1 %
- Rank Correlation< 1 %
- End IF< 1 %
- Color Manager< 1 %
Excel Reader (XLS)< 1 %- Column Filter (legacy)< 1 %
- Row Filter (Labs)< 1 %
- String Manipulation (Multi Column)< 1 %
- Double Configuration< 1 %
- File Reader (Complex Format)< 1 %
- Row Aggregator< 1 %
- Excel Writer< 1 %
- List Files/Folders< 1 %
- Outlier Removal< 1 %
- Chemical Terms< 1 %
Variable to Table Row< 1 %Database Reader< 1 %Loop End< 1 %- Chunk Loop Start< 1 %
- X-Partitioner< 1 %
- Gradient Boosted Trees Predictor (Regression)< 1 %
- Tree Ensemble Predictor (Regression)< 1 %
- Numeric Binner< 1 %
- Category to Number< 1 %
String To Number< 1 %- Column Aggregator< 1 %
- Column to Grid< 1 %
- One to Many< 1 %
- Nominal Value Row Filter< 1 %
- Partitioning< 1 %
- Missing Value (Apply)< 1 %
- Rank< 1 %
- Table Transposer< 1 %
- Unpivot< 1 %
- Renderer to Image< 1 %
- Statistics< 1 %
- Gaussian Distributed Assigner< 1 %
Excel Reader (XLS)< 1 %- Java Snippet (simple)< 1 %
- Python Source (legacy)< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Molecular Properties< 1 %
- RDKit Descriptor Calculation< 1 %
- k-Means< 1 %
- Numeric Scorer< 1 %
- SMOTE< 1 %
- Random Forest Predictor< 1 %
- Random Forest Predictor (Regression)< 1 %
- Case Converter< 1 %
Cell Replacer< 1 %- Constant Value Column Filter< 1 %
String To Number (PMML)< 1 %- Top k Row Filter< 1 %
- Numeric Outliers< 1 %
- Empty Table Switch< 1 %
- Extract Table Dimension< 1 %
- Modify Time< 1 %
- Moving Aggregator< 1 %
- Table Row to Variable< 1 %
- Variable to Table Row< 1 %
- File Reader< 1 %
- Column List Loop Start< 1 %
- Data Explorer< 1 %
- Independent groups t-test< 1 %
- DB Update< 1 %
- Column Filter Widget< 1 %
- Python Script (legacy)< 1 %
- XPath< 1 %
- Parameter Optimization Loop End< 1 %
- CASE Switch End< 1 %
- Table Column to Variable< 1 %
- Value Lookup< 1 %
- Row Splitter (Labs)< 1 %
- CSV Writer< 1 %
- Molecule Properties< 1 %
- String to Date/Time (legacy)< 1 %
- RDKit Optimize Geometry< 1 %
- Loop End (Column Append)< 1 %
Counting Loop Start< 1 %- Linear Regression Learner< 1 %
- Table Validator (Reference)< 1 %
- Reference Column Filter< 1 %
- String Manipulation (Variable)< 1 %
- H2O to Table< 1 %
Python Script (1⇒1)< 1 %- Date&Time to legacy Date&Time< 1 %
- Try (Data Ports)< 1 %
- Add Empty Rows< 1 %
- Column Renamer (Dictionary)< 1 %
- Quasirandom Sequence Generator (Apache)< 1 %
- R Predictor< 1 %
- Latitude/Longitude to Coordinate< 1 %
- Odds and Risk Ratios< 1 %
- DB Writer< 1 %
- Mass Calculator< 1 %
Flow Variable IF Switch< 1 %- Z-Primes (PC x NC)< 1 %
- Create Collection Column< 1 %
Table Column to Variable< 1 %Loop End (2 ports)< 1 %Recursive Loop End< 1 %Variable Loop End< 1 %- Polynomial Regression Learner< 1 %
Scorer< 1 %- Cell Splitter By Position< 1 %
Double To Int< 1 %- IF Switch< 1 %
- Cache< 1 %
- Box Plot (legacy)< 1 %
- Time Series Generator< 1 %
- DL4J Feedforward Predictor (Regression) (legacy)< 1 %
- JSON Path< 1 %
- Time to String (legacy)< 1 %
- RDKit Open 3D Alignment< 1 %
Column Distance< 1 %- R Snippet< 1 %
Table Row to Variable< 1 %- Number to String (PMML)< 1 %
CASE Switch Data (End)< 1 %Color Appender< 1 %- Number Filter< 1 %
- String Configuration< 1 %
- String Input (legacy)< 1 %
- Fingerprint Similarity< 1 %
- DB Insert< 1 %
- Modify Date< 1 %
- Price Maximize< 1 %
- MolSearch< 1 %
- Standardizer< 1 %
ChemSpider (deprecated)< 1 %Variable to Table Column< 1 %Database Connection Table Reader< 1 %- Group Loop Start< 1 %
- Fuzzy Rule Predictor< 1 %
- PNN Predictor< 1 %
PCA Inversion< 1 %Simple Regression Tree Predictor< 1 %Number To String< 1 %Column Appender< 1 %- Column Name Extractor< 1 %
- Lag Column< 1 %
- Low Variance Filter< 1 %
- Normalizer (Apply)< 1 %
- Ruleset to Table< 1 %
- Extract Table Spec< 1 %
- Crosstab< 1 %
- ROC Curve (legacy)< 1 %
- SDF Stripper< 1 %
DL Network Executor< 1 %- TF< 1 %
- Weka Cluster Assigner (3.7)< 1 %
- Line Plot (JavaScript)< 1 %
- Rowset Filter< 1 %
- Parameter Optimization Loop Start< 1 %
- R Snippet< 1 %
- R to Table< 1 %
- Date/Time Shift (legacy)< 1 %
- Extract Time Window (legacy)< 1 %
- Mask Date/Time (legacy)< 1 %
- XLogP< 1 %
- Window Slider< 1 %
XLS Formatter (apply)< 1 %- Customer Distributions< 1 %
Flow Variable End IF< 1 %- Benchmark Start< 1 %
- Coordinate Row Filter< 1 %
- MolConverter< 1 %
- Split Collection Column< 1 %
Table Row to Variable< 1 %List Files< 1 %Model Writer< 1 %Naive Bayes Predictor< 1 %- Naive Bayes Predictor< 1 %
- SVM Predictor< 1 %
Random Forest Predictor< 1 %Random Forest Predictor (Regression)< 1 %- Gradient Boosted Trees Predictor< 1 %
Tree Ensemble Predictor< 1 %- Correlation Filter< 1 %
- Table Validator< 1 %
- CAIM Binner< 1 %
- Domain Calculator< 1 %
- Edit Nominal Domain< 1 %
- HiLite Row Splitter< 1 %
- Reference Row Splitter< 1 %
- Denormalizer (PMML)< 1 %
- Shuffle< 1 %
- Target Shuffling< 1 %
- Decision Tree to Ruleset< 1 %
- One-way ANOVA< 1 %
Merge Variables< 1 %- Random Label Assigner< 1 %
- Stresser< 1 %
- Distance Matrix Calculate< 1 %
- Keras Network Executor< 1 %
- SAS7BDAT Reader< 1 %
Excel Sheet Appender (XLS)< 1 %Excel Writer (XLS)< 1 %- Dictionary Filter< 1 %
- Punctuation Erasure< 1 %
- Google Sheets Reader< 1 %
Python Script (2⇒1)< 1 %- Python Edit Variable (legacy)< 1 %
String Input (legacy)< 1 %- Duration to Number< 1 %
- Time Field Extractor (legacy)< 1 %
- Preset Date/Time (legacy)< 1 %
- Table to HTML String< 1 %
- Molecule to CDK< 1 %
- RDKit Diversity Picker< 1 %
- RDKit To Molecule< 1 %
- Speedy SMILES Strip Stereochemistry< 1 %
- Number Formatter< 1 %
- Create File Name (legacy)< 1 %
- SOTA Predictor< 1 %
- PMML Gradient Boosted Trees Predictor (Regression)< 1 %
- Table Difference Finder< 1 %
- Single sample t-test< 1 %
- Paired t-test< 1 %
- Parquet Reader< 1 %
- Parallel Chunk End< 1 %
- Parameterized DB Query Reader< 1 %
- Prediction Fusion< 1 %
- H2O Generalized Linear Model Learner (Regression)< 1 %
- Radar Plot Appender< 1 %
- Date&Time Configuration< 1 %
- Double Input (legacy)< 1 %
- Generic JavaScript View (JavaScript)< 1 %
- Interactive Value Filter Widget< 1 %
- Nominal Row Filter Widget< 1 %
- Double Widget< 1 %
- JSON to Table< 1 %
- Window Loop Start< 1 %
Views
- This node has no views
Workflows
00_Guided_Labeling_for_Document_Classification_(legacy)KNIME Hub- 00_Topic_Modeling_with_Verified_ComponentsKNIME Hub
- 00_Topic_Modeling_with_Verified_ComponentsKNIME Hub
- 01_Compute_LIMEsKNIME Hub
- 01_Compute_LIMEsKNIME Hub
- Show all 668 workflows
Links
- 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
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.