This node determines the most specific type in the configured string columns and changes the column types accordingly. The type order is to first check if the values are dates, then integer, long, double, and finally string. For dates a custom format can be specified.
Options
Manual Selection
Wildcard/Regex Selection
Popular Successors
- Excel Writer7 %
- Joiner4 %
- GroupBy4 %
- CSV Writer3 %
- String to Number3 %
Row Filter (deprecated)2 %- Column Filter2 %
- Missing Value2 %
- String Manipulation2 %
- Rule-based Row Filter2 %
- Math Formula2 %
- Number to String2 %
Column Rename2 %- String to Date&Time2 %
- Column Expressions2 %
- Concatenate2 %
- Rule Engine2 %
- Column Resorter1 %
- Duplicate Row Filter1 %
- DB Writer1 %
- Sorter< 1 %
Column Appender< 1 %- Math Formula (Multi Column)< 1 %
- Loop End< 1 %
- Pivot< 1 %
- Table Manipulator< 1 %
Linear Correlation< 1 %- Constant Value Column< 1 %
Cell Splitter< 1 %- Column Auto Type Cast< 1 %
- Column Appender< 1 %
Table Row to Variable< 1 %- Missing Value Column Filter< 1 %
Row Splitter (deprecated)< 1 %- Reference Row Filter< 1 %
Concatenate (Optional in)< 1 %- Statistics< 1 %
- RowID< 1 %
- Cell Splitter< 1 %
- Rule-based Row Splitter< 1 %
Variable to Table Column< 1 %- Column Merger< 1 %
- Nominal Value Row Filter< 1 %
- Binner (Dictionary)< 1 %
Table Column to Variable< 1 %- Number to Category (Apply)< 1 %
- Column Renamer (Dictionary)< 1 %
- Java IF (Table)< 1 %
- Double to Integer< 1 %
- Value Counter< 1 %
- Table Difference Checker< 1 %
- Number Rounder< 1 %
- Conditional Box Plot (JavaScript)< 1 %
- Split Collection Column< 1 %
- Group Loop Start< 1 %
- Table Validator< 1 %
- String Manipulation (Multi Column)< 1 %
- String Replacer< 1 %
XLS Sheet Appender< 1 %- Send to Tableau Server< 1 %
- Modify Date< 1 %
- Table Column to Variable< 1 %
- Column Renamer< 1 %
- Data Explorer< 1 %
- Statistics View< 1 %
- Run Garbage Collector< 1 %
Database Writer< 1 %- Table Writer< 1 %
Double To Int< 1 %- Nominal Value Row Splitter< 1 %
- Table Transposer< 1 %
- Date&Time Difference< 1 %
- Column Aggregator< 1 %
- Scatter Matrix (legacy)< 1 %
Parquet Writer< 1 %- SDF Writer< 1 %
- DB Table Creator< 1 %
- Date&Time to String< 1 %
- XPath< 1 %
- Partitioning< 1 %
- Interactive Pie chart (legacy)< 1 %
- Color Manager< 1 %
- SDF Inserter< 1 %
- Table to R< 1 %
Extract Date&Time Fields< 1 %- Date&Time Part Extractor< 1 %
Loop End< 1 %- Linear Regression Learner< 1 %
- Column Rename (Regex)< 1 %
- Row Sampling< 1 %
- Unpivot< 1 %
- DB Insert< 1 %
- Date&Time-based Row Filter< 1 %
- XLS Control Table Generator< 1 %
- Z-Primes (PC x NC)< 1 %
- Catch Errors (Data Ports)< 1 %
Database Looping< 1 %- Decision Tree Learner< 1 %
- Reference Row Splitter< 1 %
- Key-Collection HiLite Translator< 1 %
- Normalizer (Apply)< 1 %
- Column Splitter< 1 %
- Conditional Box Plot (legacy)< 1 %
- Interactive Table (legacy)< 1 %
- Parquet Writer< 1 %
- Line Chart (JFreeChart)< 1 %
XLS Writer< 1 %- Normalize Plates (POC)< 1 %
- PCA Compute< 1 %
- Numeric Binner< 1 %
- Column to Grid< 1 %
- Cross Joiner< 1 %
- Table Validator (Reference)< 1 %
- Subset Matcher< 1 %
- Number to String (PMML)< 1 %
- 2D Density Plot (Plotly)< 1 %
- H2O MOJO Predictor (Classification)< 1 %
- OSM Map View< 1 %
- String to Path< 1 %
- Google Sheets Updater< 1 %
- Column Filter Configuration< 1 %
- TIBCO Spotfire File Writer< 1 %
Database Table Creator< 1 %- Java Snippet< 1 %
- Loop End (Column Append)< 1 %
Recursive Loop End (2 ports)< 1 %Recursive Loop End< 1 %- Table Row to Variable Loop Start< 1 %
- X-Partitioner< 1 %
- Hierarchical Clustering< 1 %
- MultiLayerPerceptron Predictor< 1 %
- RProp MLP Learner< 1 %
- Polynomial Regression Learner< 1 %
- Scorer< 1 %
- Lag Column< 1 %
- Edit Nominal Domain (Dictionary)< 1 %
- Filter Apply Row Splitter< 1 %
- Row Filter (Labs)< 1 %
Joiner< 1 %- Low Variance Filter< 1 %
- Normalizer< 1 %
- Reference Column Resorter< 1 %
- Row to Column Names< 1 %
- Ungroup< 1 %
- Renderer to Image< 1 %
- Rank Correlation< 1 %
- Empty Table Switch< 1 %
- End IF< 1 %
- IF Switch< 1 %
- Extract Table Dimension< 1 %
- Interactive Histogram (legacy)< 1 %
- Lift Chart (legacy)< 1 %
- DB Update< 1 %
DB Table Creator< 1 %- Counter Generation< 1 %
- Random Label Assigner (Data)< 1 %
TIBCO File Writer< 1 %- Java Snippet (simple)< 1 %
- Tableau Writer< 1 %
Tableau Writer (TDE)< 1 %- Table Editor (JavaScript)< 1 %
- Table to JSON< 1 %
- Date Field Extractor (legacy)< 1 %
- String to Date/Time (legacy)< 1 %
- XLS Control Table from Cell Range< 1 %
- URL Encode< 1 %
- Create Well Position< 1 %
- Write To Excel Template (deprecated)< 1 %
- 2D/3D Scatterplot< 1 %
- Create Collection Column< 1 %
- Binary Objects to Strings< 1 %
- PNGs to Binary Objects< 1 %
- Try (Data Ports)< 1 %
- Variable to Table Column< 1 %
- Table Row to Variable< 1 %
- Variable to Table Row< 1 %
CSV Writer< 1 %Parameterized Database Query< 1 %- Image Writer (Table)< 1 %
Table Writer< 1 %- Counting Loop Start< 1 %
- Chunk Loop Start< 1 %
- Column List Loop Start< 1 %
- PNN Predictor< 1 %
- k-Means< 1 %
Scorer< 1 %- Auto-Binner< 1 %
- Case Converter< 1 %
Cell Replacer< 1 %- Cell Splitter By Position< 1 %
- Column Combiner< 1 %
- Category to Number< 1 %
String To Number< 1 %- Column Name Extractor< 1 %
- Many to One< 1 %
- One to Many< 1 %
- Linear Correlation< 1 %
- Correlation Filter< 1 %
- Domain Calculator< 1 %
- Edit Nominal Domain< 1 %
- Reference Column Filter< 1 %
- Constant Value Column Filter< 1 %
- Missing Value (Apply)< 1 %
- String to Number (PMML)< 1 %
- Rank< 1 %
- String Splitter (Regex)< 1 %
- Numeric Row Splitter< 1 %
- Table Difference Finder< 1 %
- Value Lookup< 1 %
- Rule Engine (Dictionary)< 1 %
- Numeric Outliers< 1 %
- Extract Table Spec< 1 %
- Histogram (legacy)< 1 %
- Pie chart (legacy)< 1 %
- Box Plot (legacy)< 1 %
- Parallel Coordinates (legacy)< 1 %
- Scatter Plot (legacy)< 1 %
- Bar Chart< 1 %
- Box Plot< 1 %
- Scatter Plot< 1 %
- Table View< 1 %
- Molecule Type Cast< 1 %
- Microsoft SQL Server Connector< 1 %
DB Loader< 1 %- DB Loader< 1 %
- DB Merge< 1 %
- DB SQL Executor< 1 %
- Bar Chart (JavaScript)< 1 %
- Contour Plot (Plotly)< 1 %
- Histogram (JavaScript)< 1 %
- Sunburst Chart (JavaScript)< 1 %
- Violin Plot (Plotly)< 1 %
- Scatter Plot (JFreeChart)< 1 %
Excel Writer (XLS)< 1 %Excel Writer (XLS)< 1 %- Excel Cell Updater< 1 %
- Spark Line Appender< 1 %
- Strings to Document< 1 %
- Value Selection Configuration< 1 %
- Column Selection (legacy)< 1 %
- Value Selection (legacy)< 1 %
- Table View (JavaScript)< 1 %
- Line Plot (JavaScript)< 1 %
- Scatter Plot (JavaScript)< 1 %
- Nominal Row Filter Widget< 1 %
- Value Selection Widget< 1 %
- String to JSON< 1 %
- JSON Path< 1 %
- JSON to Table< 1 %
- Python Predictor (legacy)< 1 %
- Python Script (legacy)< 1 %
- R Snippet< 1 %
- R View (Table)< 1 %
- Date&Time to legacy Date&Time< 1 %
- Legacy Date&Time to Date&Time< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Date&Time Shift< 1 %
- Time Difference (legacy)< 1 %
- Geo Distances< 1 %
- Column Packer< 1 %
Python Plot< 1 %- Upload (legacy)< 1 %
Database Update< 1 %Variable Loop End< 1 %- Decision Tree Predictor< 1 %
PCA Apply< 1 %- Random Forest Learner< 1 %
- Random Forest Predictor< 1 %
Number To String (PMML)< 1 %String To Number (PMML)< 1 %Color Appender< 1 %- Parameterized DB Query Reader< 1 %
- k-Medoids< 1 %
- PMML Predictor< 1 %
Send to Tableau Server (TDE)< 1 %- Date/Time Shift (legacy)< 1 %
- Run Heavy Garbage Collector< 1 %
- Outlier Removal< 1 %
- ARIMA Visualization< 1 %
- Download / Upload from List (legacy)< 1 %
Variable to Table Column< 1 %- Create File Name (legacy)< 1 %
Table Row To Variable Loop Start< 1 %- Feature Selection Loop End< 1 %
Naive Bayes Predictor< 1 %PCA< 1 %- Logistic Regression Learner< 1 %
- Regression Predictor< 1 %
- PCA< 1 %
- Gradient Boosted Trees Learner< 1 %
- Column Comparator< 1 %
Normalizer< 1 %- Shuffle< 1 %
- String Manipulation (Variable)< 1 %
- Cache< 1 %
- Smiles Directory Writer< 1 %
- TF< 1 %
- Stop Word Filter< 1 %
- Bag Of Words Creator< 1 %
- Path to String< 1 %
- Container Output (Table)< 1 %
- Columns to JSON< 1 %
- Modify Time< 1 %
- Moving Aggregator< 1 %
- Table to HTML String< 1 %
- RDKit Add Hs< 1 %
- RDKit Descriptor Calculation< 1 %
- RDKit From Molecule< 1 %
- RDKit Fingerprint< 1 %
- RDKit To Molecule< 1 %
- Library Filter< 1 %
- Type< 1 %
- Polygon Properties< 1 %
CV< 1 %- Convert to R< 1 %
- Open in R< 1 %
- Advanced MolConverter< 1 %
- MolExporter< 1 %
- Table to String< 1 %
- Strings to Binary Objects< 1 %
- Java Edit Variable< 1 %
- Recursive Loop Start< 1 %
Recursive Loop Start< 1 %Naive Bayes Learner< 1 %Logistic Regression Learner< 1 %- Association Rule Learner< 1 %
- Add Empty Rows< 1 %
- Expand Byte Vector< 1 %
Number To String< 1 %- Filter Apply< 1 %
Rank Correlation< 1 %- Numeric Outliers (Apply)< 1 %
- One-way ANOVA< 1 %
CASE Switch Data (End)< 1 %- Line Plot (legacy)< 1 %
- DB Column Filter< 1 %
- Numeric Distances< 1 %
- Similarity Search< 1 %
- Keras Network Learner< 1 %
- Stacked Area Chart (Plotly)< 1 %
- Table to H2O< 1 %
Microsoft Authenticator (Deprecated)< 1 %- Geo-Coordinate Row Filter< 1 %
Excel Sheet Appender (XLS)< 1 %Tableau Writer (Hyper)< 1 %- Document Vector< 1 %
- Heatmap (JavaScript)< 1 %
- Interactive Value Filter Widget< 1 %
- Container Input (Table)< 1 %
- Data Row to Image< 1 %
- Object Inserter< 1 %
Python Script (1⇒1)< 1 %Python Script (2⇒1)< 1 %- Python View (legacy)< 1 %
Column Selection QuickForm (legacy)< 1 %- String to Duration< 1 %
- Modify Time Zone< 1 %
- Extract Time Window (legacy)< 1 %
- Mask Date/Time (legacy)< 1 %
- Time to String (legacy)< 1 %
- RDKit To InChI< 1 %
Regex Extractor< 1 %- Navigate< 1 %
- InChi< 1 %
- Duplicate Remover< 1 %
- Domain - Leverage< 1 %
- PMI Kernel Density Plot< 1 %
- Sparse To Dense< 1 %
IF Switch (Flow Variable Value)< 1 %Flow Variable End IF< 1 %Flow Variable IF Switch< 1 %- Benchmark End< 1 %
- Notched Boxplot (JFreechart)< 1 %
- Set To List< 1 %
Expand Well Position< 1 %- Number Formatter< 1 %
- Range Filter< 1 %
- Multivariate Z-Primes< 1 %
- R Snippet< 1 %
- Aqueous Solubility< 1 %
- Standardizer< 1 %
- MolConverter< 1 %
- Simple Search< 1 %
Element Selector< 1 %- ARIMA Predictor< 1 %
- Copy/Move Files (legacy)< 1 %
- Delete Files (legacy)< 1 %
- URL to File Path< 1 %
- Try (Variable Ports)< 1 %
- Active Branch Inverter< 1 %
Table Column to Variable< 1 %Table Column to Variable< 1 %Table Row to Variable< 1 %- Table to Image< 1 %
- ARFF Writer< 1 %
CSV Reader< 1 %- Feature Selection Filter< 1 %
Loop End (2 ports)< 1 %Counting Loop Start< 1 %Variable Condition Loop End< 1 %- Recursive Loop End< 1 %
Recursive Loop Start (2 ports)< 1 %- X-Aggregator< 1 %
- Fuzzy Rule Learner< 1 %
- Fuzzy c-Means< 1 %
- K Nearest Neighbor< 1 %
- SMOTE< 1 %
- SVM Learner< 1 %
- PCA Apply< 1 %
Random Forest Predictor< 1 %Gradient Boosted Trees Learner (Regression)< 1 %- Gradient Boosted Trees Learner (Regression)< 1 %
- Tree Ensemble Learner< 1 %
Random Forest Learner< 1 %- Random Forest Learner (Regression)< 1 %
- Random Forest Predictor (Regression)< 1 %
- Simple Regression Tree Learner< 1 %
- Distance Matrix Pair Extractor< 1 %
- Auto-Binner (Apply)< 1 %
- Bootstrap Sampling< 1 %
- Create Byte Vector< 1 %
- Category to Number (Apply)< 1 %
- Edit Numeric Domain< 1 %
- Equal Size Sampling< 1 %
- Reference Column Splitter< 1 %
- One to Many (PMML)< 1 %
- Normalizer (PMML)< 1 %
Number To String (PMML)< 1 %String Replace (Dictionary)< 1 %- Top k Row Filter< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Single sample t-test< 1 %
CASE Switch Data (Start)< 1 %- Create Temp Dir (legacy)< 1 %
Merge Variables< 1 %- Crosstab< 1 %
- Enrichment Plotter (legacy)< 1 %
- HiLite Table (legacy)< 1 %
- Size Manager< 1 %
- ROC Curve (legacy)< 1 %
ORC Writer< 1 %- ORC Writer< 1 %
Parquet Writer< 1 %- Table to Spark< 1 %
MySQL Connector< 1 %- DB Reader< 1 %
- DB Table Selector< 1 %
- Conditional Label Assigner< 1 %
- Random Number Assigner< 1 %
- One Row to Many< 1 %
- Random Boolean Assigner< 1 %
- Random Item Inserter< 1 %
- Random Matcher< 1 %
- Java Distance< 1 %
- Mahalanobis Distance< 1 %
- String Distances< 1 %
- Distance Matrix Calculate< 1 %
K Nearest Neighbor (Distance Function)< 1 %- Box Plot (JavaScript)< 1 %
- Line Plot (Plotly)< 1 %
- Parallel Coordinates Plot (JavaScript)< 1 %
- Pie/Donut Chart (JavaScript)< 1 %
- Cell to Model< 1 %
- Variable Expressions< 1 %
Table to HTML< 1 %- OpenBabel< 1 %
- Generic Web Service Client< 1 %
- DL4J Feedforward Learner (Classification) (legacy)< 1 %
- DL4J Feedforward Predictor (Regression) (legacy)< 1 %
- External Tool< 1 %
- Bar Chart (JFreeChart)< 1 %
- HeatMap (JFreeChart)< 1 %
- Interval Chart (JFreeChart)< 1 %
- Index Query< 1 %
- OSM Map to Image< 1 %
Excel Reader (XLS)< 1 %Excel Sheet Appender (XLS)< 1 %Send to Power BI< 1 %- Send to Power BI< 1 %
- Java Snippet Row Filter< 1 %
Send to Tableau Server (Hyper)< 1 %- Topic Extractor (Parallel LDA)< 1 %
- Case Converter< 1 %
- Diacritic Remover< 1 %
- Number Filter< 1 %
- Punctuation Erasure< 1 %
- Replacer< 1 %
- Tag Filter< 1 %
Bag of Words Creator< 1 %- Document Data Extractor< 1 %
Document vector< 1 %- String to Term< 1 %
- JPMML Classifier< 1 %
- Column Filter (legacy)< 1 %
- Range Slider Filter Definition (legacy)< 1 %
- Value Filter (legacy)< 1 %
- ROC Curve (JavaScript)< 1 %
- Tag Cloud (JavaScript)< 1 %
- Slider Widget< 1 %
- JSON Writer< 1 %
- JSON to XML< 1 %
- Binary Classification Inspector< 1 %
- Hierarchy Extractor< 1 %
Python Predictor< 1 %Python Script (1⇒1)< 1 %Python Script (2⇒1)< 1 %- Add Table to R< 1 %
- R Predictor< 1 %
- Data to Report (BIRT)< 1 %
- GET Request< 1 %
- Time Field Extractor (legacy)< 1 %
- Moving Average< 1 %
- Twitter Users< 1 %
XGBoost Tree Ensemble Learner< 1 %- XML Column Combiner< 1 %
Table to HTML String< 1 %- Row Splitter (col+)< 1 %
- Remove Empty Rows< 1 %
- Molecule to CDK< 1 %
- RDKit Canon SMILES< 1 %
- RDKit Molecule Substructure Filter< 1 %
- RDKit Salt Stripper< 1 %
Location Extractor< 1 %- Latitude/Longitude to Coordinate< 1 %
- HTTP Retriever< 1 %
- Quit WebDriver< 1 %
Views
- This node has no views
Workflows
!Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub- (3D) Fragment library design workflowKNIME Hub
- 00 Main MenuKNIME Hub
- 00 Main MenuKNIME Hub
- 00_Guided_Labeling_for_Document_Classification_(legacy)KNIME Hub
- Show all 962 workflows
Links
- Which node should I use for data type changes?by armingrudd on 2019-07-26forum.knime.com/p/66428
- cannot select some columns in Nominal Value Row Filter nodeby armingrudd on 2019-10-01forum.knime.com/p/71430
- change Unknown column type to stringby HansS on 2024-06-12forum.knime.com/p/260181
- Date filteringby armingrudd on 2019-06-18forum.knime.com/p/62463
- Test Column Datatype Inside Loopby izaychik63 on 2022-03-14forum.knime.com/p/150754
- Show all 6 links
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.