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
- GroupBy4 %
- Math Formula4 %
Row Filter (deprecated)2 %- String to Number2 %
- Missing Value2 %
- Rule-based Row Filter2 %
- Excel Writer2 %
- Column Filter2 %
- Partitioning1 %
- Concatenate1 %
- Math Formula (Multi Column)1 %
- Rule Engine1 %
- String to Date&Time1 %
- Normalizer (PMML)1 %
- Number to String1 %
Column Rename1 %Joiner< 1 %- String to Number (PMML)< 1 %
- Number Rounder< 1 %
- Line Plot (JavaScript)< 1 %
- Scatter Plot (JavaScript)< 1 %
- Regression Predictor< 1 %
- Unpivot< 1 %
- Table Row to Variable< 1 %
- CSV Writer< 1 %
Scorer< 1 %- String Manipulation (Multi Column)< 1 %
- Histogram (legacy)< 1 %
Excel Writer (XLS)< 1 %Database Writer< 1 %- K Nearest Neighbor< 1 %
- MultiLayerPerceptron Predictor< 1 %
- Numeric Binner< 1 %
- Column Appender< 1 %
- Linear Correlation< 1 %
- String Manipulation< 1 %
- ROC Curve (legacy)< 1 %
- DB Writer< 1 %
- Linear Regression Learner< 1 %
- Auto-Binner< 1 %
Cell Replacer< 1 %- Column Aggregator< 1 %
- Column Resorter< 1 %
Linear Correlation< 1 %- Nominal Value Row Filter< 1 %
- Normalizer< 1 %
- Sorter< 1 %
- Rule-based Row Splitter< 1 %
- Ruleset Predictor< 1 %
- Numeric Outliers< 1 %
- Interactive Histogram (legacy)< 1 %
- Pie chart (legacy)< 1 %
- Interactive Pie chart (legacy)< 1 %
- Scatter Plot (JFreeChart)< 1 %
Excel Sheet Appender (XLS)< 1 %- Legacy Date&Time to Date&Time< 1 %
Database Looping< 1 %- X-Partitioner< 1 %
- k-Means< 1 %
- Decision Tree Learner< 1 %
- Decision Tree Predictor< 1 %
- RProp MLP Learner< 1 %
- Logistic Regression Learner< 1 %
- Scorer< 1 %
- Numeric Scorer< 1 %
- Cell Splitter< 1 %
- Category to Number (Apply)< 1 %
- Category to Number< 1 %
- Column Renamer< 1 %
- Column Rename (Regex)< 1 %
- One to Many< 1 %
- Constant Value Column< 1 %
- Cross Joiner< 1 %
- Double to Integer< 1 %
- Duplicate Row Filter< 1 %
- Reference Column Filter< 1 %
Row Splitter (deprecated)< 1 %- Reference Row Filter< 1 %
- Joiner< 1 %
- Table Manipulator< 1 %
- Pivot< 1 %
- Numeric Binner (PMML)< 1 %
- Missing Value (Apply)< 1 %
- Number to String (PMML)< 1 %
- Table Transposer< 1 %
- Value Lookup< 1 %
- Rank Correlation< 1 %
- Data Explorer< 1 %
- Statistics< 1 %
- Conditional Box Plot (legacy)< 1 %
- Box Plot (legacy)< 1 %
- Color Manager< 1 %
- Interactive Table (legacy)< 1 %
- Statistics View< 1 %
- DB Loader< 1 %
DB Table Creator< 1 %- Column Expressions (legacy)< 1 %
- Line Chart (JFreeChart)< 1 %
Excel Writer (XLS)< 1 %- Table View (JavaScript)< 1 %
- ROC Curve (JavaScript)< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Date&Time Shift< 1 %
- String to Date/Time (legacy)< 1 %
- Latitude/Longitude to Coordinate< 1 %
- PMML Transformation Appender< 1 %
- Column Combiner< 1 %
- Column Merger< 1 %
- Missing Value Column Filter< 1 %
- Scatter Plot (legacy)< 1 %
- Desirability Ranking< 1 %
- Naive Bayes Predictor< 1 %
- Hierarchical Clustering< 1 %
- Entropy Scorer< 1 %
- SVM Learner< 1 %
- PCA< 1 %
- Gradient Boosted Trees Predictor (Regression)< 1 %
- Number to Category (Apply)< 1 %
- Value Counter< 1 %
- Line Plot (legacy)< 1 %
- Scatter Matrix (legacy)< 1 %
- PMML Predictor< 1 %
- Java Snippet (simple)< 1 %
- Value Selection Widget< 1 %
- Date&Time to String< 1 %
- Plate Heatmap Viewer< 1 %
- SMOTE< 1 %
Concatenate (Optional in)< 1 %Column Appender< 1 %- Correlation Filter< 1 %
- Nominal Value Row Splitter< 1 %
Normalizer< 1 %- RowID< 1 %
- String Replacer< 1 %
- Parallel Coordinates (legacy)< 1 %
- Keras Network Learner< 1 %
- DL Python Network Learner< 1 %
- HeatMap (JFreeChart)< 1 %
- Range Slider Filter Definition (legacy)< 1 %
- Python Script (legacy)< 1 %
- Find Elements< 1 %
- Number Formatter< 1 %
- Strings to Binary Objects< 1 %
- Catch Errors (Data Ports)< 1 %
- Variable to Table Column< 1 %
- Table Column to Variable< 1 %
CSV Writer< 1 %PMML Writer< 1 %- Java Snippet< 1 %
- Feature Selection Filter< 1 %
- Feature Selection Loop Start (1:1)< 1 %
- Loop End< 1 %
Loop End< 1 %Counting Loop Start< 1 %- Chunk Loop Start< 1 %
- Column List Loop Start< 1 %
Generic Loop Start< 1 %- Group Loop Start< 1 %
- Table Row to Variable Loop Start< 1 %
- X-Aggregator< 1 %
- Naive Bayes Learner< 1 %
- Fuzzy Rule Learner< 1 %
- PNN Learner (DDA)< 1 %
- PNN Predictor< 1 %
- Cluster Assigner< 1 %
- Logistic Regression Predictor< 1 %
- Polynomial Regression Learner< 1 %
- SVM Predictor< 1 %
- Tree Ensemble Learner (Regression)< 1 %
- Random Forest Learner< 1 %
- Simple Regression Tree Learner< 1 %
- Auto-Binner (Apply)< 1 %
- Create Bit Vector< 1 %
- Bootstrap Sampling< 1 %
- Cell Splitter By Position< 1 %
- Column Comparator< 1 %
Number To String< 1 %- String to SVG< 1 %
- Row Filter (Labs)< 1 %
- One to Many (PMML)< 1 %
- XML to PMML< 1 %
- Rank< 1 %
- String Splitter (Regex)< 1 %
- Numeric Row Splitter< 1 %
- Column Splitter< 1 %
String Replace (Dictionary)< 1 %- Ruleset Editor< 1 %
- Ruleset to Table< 1 %
Rank Correlation< 1 %- Kolmogorov-Smirnov Test< 1 %
- Extract Table Dimension< 1 %
- Enrichment Plotter (legacy)< 1 %
- PMML Transformation Apply< 1 %
- DB Insert< 1 %
- One Row to Many< 1 %
- Numeric Distances< 1 %
- DL Python Network Executor< 1 %
- Line Plot (Plotly)< 1 %
- Stacked Area Chart (Plotly)< 1 %
- Table to H2O< 1 %
- GroupBy Bar Chart (JFreeChart)< 1 %
- Excel Reader< 1 %
- Frequency Filter< 1 %
- Stop Word Filter< 1 %
- Weka Predictor (3.7)< 1 %
- List Files/Folders< 1 %
- Lift Chart (JavaScript)< 1 %
Python Script (1⇒1)< 1 %- Python View (legacy)< 1 %
- Data to Report (BIRT)< 1 %
- Duration to Number< 1 %
- Date&Time Part Extractor< 1 %
- Date/Time Shift (legacy)< 1 %
- XGBoost Predictor (Regression)< 1 %
Views
- This node has no views
Workflows
american house rate 2KNIME Hub- Binding Poses and Energies CalculationKNIME Hub
- Calculo_Comisiones_NEWKNIME Forum
- Excel - Import selected Columns and Cells - KNIME Forum (78689)KNIME Hub
- Excel - Import selected Columns and Cells - KNIME Forum (78689)KNIME Forum
- Show all 37 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.