This Node Is Deprecated — This node is kept for backwards-compatibility, but the usage in new workflows is no longer recommended. The documentation below might contain more information.
Converts strings in a column (or a set of columns) to numbers. If the node fails to parse a string, it will generate a missing cell and append a warning message to the KNIME Console with detailed information.
Options
Popular Successors
Joiner10 %- Partitioning7 %
- Missing Value6 %
String To Number4 %- Normalizer3 %
- Color Manager3 %
Row Filter (deprecated)3 %- k-Means2 %
String To Number (PMML)2 %- Rule Engine2 %
Column Rename2 %Number To String (PMML)2 %- Statistics2 %
- Rule-based Row Filter2 %
- RProp MLP Learner2 %
- Linear Regression Learner2 %
Database Writer1 %- Interactive Table (legacy)1 %
CSV Writer1 %- Double to Integer1 %
Row Splitter (deprecated)1 %- ROC Curve (legacy)1 %
- String Manipulation1 %
Excel Writer (XLS)< 1 %- Category to Number< 1 %
- Regression Predictor< 1 %
- Normalizer (PMML)< 1 %
- Scatter Plot (legacy)< 1 %
Loop End< 1 %- Auto-Binner< 1 %
Linear Correlation< 1 %- String to Date&Time< 1 %
- Interactive Histogram (legacy)< 1 %
- Java Snippet< 1 %
Numeric Scorer< 1 %- SMOTE< 1 %
- Numeric Binner< 1 %
- Number to Category (Apply)< 1 %
- Histogram (legacy)< 1 %
- Math Formula (Multi Column)< 1 %
Scorer< 1 %- Column Resorter< 1 %
- Domain Calculator< 1 %
Normalizer< 1 %- Sorter< 1 %
- Line Plot (legacy)< 1 %
- PMML to Cell< 1 %
- Random Forest Learner (Regression)< 1 %
- PMML Transformation Appender< 1 %
- Column Aggregator< 1 %
- Constant Value Column< 1 %
- Pivot< 1 %
- Number Rounder< 1 %
- Rule-based Row Splitter< 1 %
Linear Discriminant Analysis< 1 %- Enrichment Plotter (legacy)< 1 %
- Bar Chart (JavaScript)< 1 %
- Line Chart (JFreeChart)< 1 %
- OSM Map View< 1 %
Extract Date&Time Fields< 1 %Table Row to Variable< 1 %Database Table Creator< 1 %- Logistic Regression Predictor< 1 %
- SVM Learner< 1 %
Concatenate (Optional in)< 1 %- Column Auto Type Cast< 1 %
- GroupBy< 1 %
- Column Filter (PMML)< 1 %
- Box Plot (legacy)< 1 %
- Distance Matrix Calculate< 1 %
Table Writer< 1 %- X-Partitioner< 1 %
- Decision Tree Learner< 1 %
K Nearest Neighbor< 1 %- MultiLayerPerceptron Predictor< 1 %
- Random Forest Learner< 1 %
- Create Bit Vector< 1 %
Cell Replacer< 1 %- Missing Value Column Filter< 1 %
- Nominal Value Row Filter< 1 %
- Many to One (PMML)< 1 %
- RowID< 1 %
- Numeric Row Splitter< 1 %
- String Replacer< 1 %
CASE Switch Data (End)< 1 %- Spark Transformations Applier< 1 %
- Bar Chart (JFreeChart)< 1 %
- Java Snippet (simple)< 1 %
- Latitude/Longitude to Coordinate< 1 %
- Fingerprint From Hexadecimal String< 1 %
- Outlier Removal< 1 %
- R Plot< 1 %
- Create Collection Column< 1 %
Counting Loop Start< 1 %- Logistic Regression Learner< 1 %
- Tree Ensemble Learner (Regression)< 1 %
Random Forest Learner< 1 %- Simple Regression Tree Learner< 1 %
- Simple Regression Tree Predictor< 1 %
- Category to Number (Apply)< 1 %
- Correlation Filter< 1 %
- Edit Nominal Domain< 1 %
- Edit Numeric Domain< 1 %
- Column Filter< 1 %
- Normalizer (Apply)< 1 %
- Numeric Binner (PMML)< 1 %
- Missing Value (Apply)< 1 %
String Replace (Dictionary)< 1 %- Unpivot< 1 %
- Decision Tree to Ruleset< 1 %
- Ruleset Predictor< 1 %
- Numeric Outliers< 1 %
- Single sample t-test< 1 %
- Interactive Pie chart (legacy)< 1 %
- PMML Predictor< 1 %
- LIBSVMLearner< 1 %
Excel Sheet Appender (XLS)< 1 %- Value Filter (legacy)< 1 %
- ROC Curve (JavaScript)< 1 %
- Date&Time to String< 1 %
- Library Filter< 1 %
- Number Formatter< 1 %
- Vector Length Normalization< 1 %
- MolSearch< 1 %
- 2D/3D Scatterplot< 1 %
- Inject Variables (Data)< 1 %
Table Column to Variable< 1 %Database Delete< 1 %Database Update< 1 %PMML Writer< 1 %Generic Loop Start< 1 %- Group Loop Start< 1 %
Naive Bayes Learner< 1 %- Naive Bayes Learner< 1 %
- Fuzzy Rule Learner< 1 %
- PNN Learner (DDA)< 1 %
- PNN Predictor< 1 %
- Fuzzy c-Means< 1 %
- Hierarchical Clustering< 1 %
Decision Tree Learner< 1 %- Decision Tree Predictor< 1 %
PCA Compute< 1 %PCA< 1 %- Polynomial Regression Learner< 1 %
Regression Predictor< 1 %Random Forest Learner (Regression)< 1 %- Gradient Boosted Trees Predictor (Regression)< 1 %
- Concatenate< 1 %
- Binner (Dictionary)< 1 %
- Cell Splitter By Position< 1 %
- Column Comparator< 1 %
Number To String< 1 %Column Appender< 1 %- One to Many< 1 %
- Cross Joiner< 1 %
- Extract Missing Value Cause< 1 %
- Constant Value Column Filter< 1 %
- Reference Row Filter< 1 %
- Reference Row Splitter< 1 %
- Normalizer Apply (PMML)< 1 %
- Denormalizer (PMML)< 1 %
- Column Splitter< 1 %
- Table Transposer< 1 %
Rule Engine< 1 %- Ruleset Editor< 1 %
- Rule Engine (Dictionary)< 1 %
- Paired t-test< 1 %
- Crosstab< 1 %
- Pie chart (legacy)< 1 %
- Scatter Matrix (legacy)< 1 %
- Spark Joiner< 1 %
- Spark Missing Value (Apply)< 1 %
- k-Medoids< 1 %
- Box Plot (JavaScript)< 1 %
- Parallel Coordinates Plot (JavaScript)< 1 %
- Pie/Donut Chart (JavaScript)< 1 %
PMML Predictor< 1 %- Table to H2O< 1 %
- Math Formula< 1 %
- Histogram Chart (JFreeChart)< 1 %
- Interval Chart (JFreeChart)< 1 %
- Pie Chart (JFreeChart)< 1 %
- Scatter Plot (JFreeChart)< 1 %
XLS Writer< 1 %- Case Converter< 1 %
- Punctuation Erasure< 1 %
Dictionary tagger< 1 %- Bag Of Words Creator< 1 %
- Document Data Extractor< 1 %
- String to Term< 1 %
- Tag Cloud< 1 %
- Weka Cluster Assigner (3.7)< 1 %
- JPMML Classifier< 1 %
- Column Filter (legacy)< 1 %
- Lift Chart (JavaScript)< 1 %
- Line Plot (JavaScript)< 1 %
- Table to JSON< 1 %
- Network Viewer< 1 %
Python Script (2⇒1)< 1 %- R Snippet< 1 %
- Date&Time to legacy Date&Time< 1 %
- Date Field Extractor (legacy)< 1 %
- Time Field Extractor (legacy)< 1 %
- Preset Date/Time (legacy)< 1 %
- String to Date/Time (legacy)< 1 %
- String to XML< 1 %
- RDKit From Molecule< 1 %
Location Extractor< 1 %
Views
- This node has no views
Workflows
Links
- No links available
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.