This node splits a column containing a collection of cells into its sub-components. If a row contains more elements than implied by the various options (see below), the remaining elements are ignored. If it contains less elements than expected, the remaining columns are filled with missing values.
Options
Popular Successors
PCA3 %- Java Snippet (simple)2 %
- Column Combiner2 %
- Column Aggregator1 %
Column Appender1 %Table Row to Variable1 %Column Rename1 %String To Number1 %Linear Correlation1 %- Column Filter1 %
XLS Writer1 %Python Script (1⇒1)1 %Cell Replacer< 1 %Excel Sheet Appender (XLS)< 1 %- Image to DataRow< 1 %
- Duplicate Row Filter< 1 %
- Value Counter< 1 %
K Nearest Neighbor (Distance Function)< 1 %- R Snippet< 1 %
Number To String< 1 %String Replace (Dictionary)< 1 %- Rule Engine (Dictionary)< 1 %
SDF Writer< 1 %- DL4J Feedforward Predictor (Classification) (legacy)< 1 %
- Image Viewer< 1 %
PCA Apply< 1 %Scorer< 1 %- String to Path< 1 %
- Table to R< 1 %
Date&Time Difference< 1 %- Split Collection Column< 1 %
- Many to One< 1 %
- String Splitter (Regex)< 1 %
- Extract Table Spec< 1 %
- JSON Transformer< 1 %
Table Row To Variable Loop Start< 1 %- Missing Value< 1 %
- Table Transposer< 1 %
- Color Manager< 1 %
- Google Sheets Updater< 1 %
- Table View (JavaScript) (legacy)< 1 %
- CIR< 1 %
CSV Writer< 1 %- Column List Loop Start< 1 %
k-Means (deprecated)< 1 %- Number to String< 1 %
- Reference Row Splitter< 1 %
Joiner< 1 %- Joiner< 1 %
- Table Partitioner< 1 %
- String Replacer< 1 %
- HeatMap (JFreeChart)< 1 %
- Term Vector< 1 %
- Python Script (legacy)< 1 %
- Append to Collection< 1 %
- Cell Splitter By Position< 1 %
- String to Number< 1 %
- One to Many< 1 %
- Cross Joiner< 1 %
- Extract Missing Value Cause< 1 %
- Subset Matcher< 1 %
- Numeric Row Splitter< 1 %
- String Manipulation< 1 %
- Ungroup< 1 %
- Box Plot (legacy)< 1 %
- Similarity Search< 1 %
- Column Expressions (legacy)< 1 %
- Association Rule Learner (Borgelt)< 1 %
- Item Set Finder (Borgelt)< 1 %
Excel Writer (XLS)< 1 %- RDKit Descriptor Calculation< 1 %
- HTTP Retriever< 1 %
- Collection to String< 1 %
- MolConverter< 1 %
- 2D/3D Scatterplot< 1 %
- XLS Coloured Writer< 1 %
- Columns to Collection< 1 %
Table Column to Variable< 1 %- Table Column to Variable< 1 %
- Table Row to Variable< 1 %
- Table to Image< 1 %
- CSV Writer< 1 %
- Image Writer (Table)< 1 %
- Java Snippet< 1 %
- Loop End< 1 %
- Loop End (Column Append)< 1 %
Loop End< 1 %- Chunk Loop Start< 1 %
- Recursive Loop Start< 1 %
- Table Row to Variable Loop Start< 1 %
- X-Partitioner< 1 %
- DBSCAN< 1 %
- MDS< 1 %
- Association Rule Learner< 1 %
- PCA Apply< 1 %
- PCA< 1 %
- Concatenate< 1 %
Concatenate (Optional in)< 1 %- Create Bit Vector< 1 %
- Create Byte Vector< 1 %
- Cell Splitter< 1 %
- Column Auto Type Cast< 1 %
- Column Comparator< 1 %
- Column Renamer< 1 %
- Column Appender< 1 %
- Column Name Extractor< 1 %
- Column Renamer (Dictionary)< 1 %
- Column Merger< 1 %
- Column Name Replacer< 1 %
- Column Resorter< 1 %
- Column to Grid< 1 %
Constant Value Column< 1 %- Reference Column Filter< 1 %
- Interactive HiLite Collector< 1 %
- Missing Value Column Filter< 1 %
- Nominal Value Row Filter< 1 %
Row Splitter (deprecated)< 1 %Row Filter (deprecated)< 1 %- Reference Row Filter< 1 %
- GroupBy< 1 %
- Key-Collection HiLite Translator< 1 %
- Low Variance Filter< 1 %
- Table Manipulator< 1 %
- Normalizer< 1 %
- Pivot< 1 %
- RowID< 1 %
- Set Operator< 1 %
- Sorter< 1 %
Column Splitter< 1 %- String Manipulation (Multi Column)< 1 %
- Unpivot< 1 %
- Renderer to Image< 1 %
- Rule-based Row Filter< 1 %
- Rule Engine< 1 %
- Rule-based Row Splitter< 1 %
- Statistics< 1 %
- IF Switch< 1 %
- Extract Table Dimension< 1 %
- Interactive Table (legacy)< 1 %
- Line Plot< 1 %
- Table View< 1 %
- Counter Generation< 1 %
- Conditional Label Assigner< 1 %
- Distance Matrix Calculate< 1 %
- Keras Network Learner< 1 %
- DL4J Feedforward Learner (Classification) (legacy)< 1 %
- Math Formula< 1 %
- Math Formula (Multi Column)< 1 %
- Index Query< 1 %
Excel Writer (XLS)< 1 %- Excel Writer< 1 %
- Column Selection (legacy)< 1 %
- Interactive Value Filter Widget< 1 %
- JSON Path< 1 %
- JSON to Table< 1 %
String to Date&Time< 1 %UNIX Timestamp to Date&Time< 1 %- XPath< 1 %
- Try (Data Ports)< 1 %
Variable to Table Column< 1 %Table Row to Variable< 1 %Database Delete< 1 %- Hierarchical Clustering< 1 %
- Hierarchical Clustering (DistMatrix)< 1 %
- PCA Compute< 1 %
- Linear Correlation< 1 %
- Table Validator< 1 %
- Table Validator (Reference)< 1 %
- Nominal Value Row Splitter< 1 %
- Reference Column Resorter< 1 %
- Molecule Type Cast< 1 %
- Rule Viewer (local) (Legacy)< 1 %
- t-SNE (L. Jonsson)< 1 %
- Column Filter (legacy)< 1 %
- Columns to JSON< 1 %
- Projector< 1 %
- Add Table to R< 1 %
- URL Extractor< 1 %
- Feature Table To List< 1 %
- Set To List< 1 %
- Labeling View< 1 %
Image Writer (Table Column)< 1 %- Decision Tree Learner< 1 %
- SMOTE< 1 %
- Distance Matrix Pair Extractor< 1 %
- Constant Value Column Filter< 1 %
- Denormalizer< 1 %
- Missing Value (Apply)< 1 %
- End IF< 1 %
- K Nearest Neighbor (Distance Function)< 1 %
- Frequency Filter< 1 %
- Nominal Row Filter Widget< 1 %
- String to JSON< 1 %
- Table to JSON< 1 %
- Data to Report (BIRT)< 1 %
String to Date/Time< 1 %IF Switch (Flow Variable Value)< 1 %- Collection Size< 1 %
- Range Splitter< 1 %
- R Snippet< 1 %
File Meta Info< 1 %- Read Images< 1 %
Database Writer< 1 %- Group Loop Start< 1 %
PCA Compute< 1 %- Linear Regression Learner< 1 %
- Random Forest Learner< 1 %
- Numeric Binner< 1 %
- Binner (Dictionary)< 1 %
- Category to Number< 1 %
- Reference Column Splitter< 1 %
- Shuffle< 1 %
- String Manipulation (Variable)< 1 %
Linear Discriminant Analysis< 1 %- Timer Info< 1 %
- Line Plot (legacy)< 1 %
- Parallel Chunk Start< 1 %
- DL Python Network Learner< 1 %
- Ligands Viewer< 1 %
- Histogram Chart (JFreeChart)< 1 %
- Line Chart (JFreeChart)< 1 %
Excel Sheet Appender (XLS)< 1 %- Java IF (Table)< 1 %
- Category to Class< 1 %
- String Matcher< 1 %
- Object Inserter< 1 %
- Assign Partition< 1 %
- Python View (legacy)< 1 %
- POST Request< 1 %
- XGBoost Predictor< 1 %
- Connectivity< 1 %
- Depiction< 1 %
- Fingerprints< 1 %
- RDKit Canon SMILES< 1 %
Regex Extractor< 1 %- Molecule Properties< 1 %
- InChi< 1 %
- Substructure Matcher< 1 %
- Uniquify IDs< 1 %
- URL Encode< 1 %
- Vector Length Normalization< 1 %
- Plate Heatmap Viewer< 1 %
- Fix Column Names< 1 %
- MarvinView< 1 %
- Automated Matched Pairs< 1 %
Element Selector< 1 %- Binary Objects to Strings< 1 %
Delete Files< 1 %- PNGs to Binary Objects< 1 %
- URL to File Path< 1 %
- Breakpoint< 1 %
- Catch Errors (Data Ports)< 1 %
Variable to Table Column< 1 %- Inject Variables (Data)< 1 %
- ARFF Writer< 1 %
- Table Writer< 1 %
Table Writer< 1 %Counting Loop Start< 1 %Generic Loop Start< 1 %Recursive Loop Start< 1 %Naive Bayes Learner< 1 %- Naive Bayes Learner< 1 %
Naive Bayes Predictor< 1 %- PNN Learner (DDA)< 1 %
- PNN Predictor< 1 %
- Fuzzy c-Means< 1 %
- Hierarchical Cluster Assigner (local)< 1 %
- Decision Tree Predictor< 1 %
K Nearest Neighbor< 1 %- K Nearest Neighbor< 1 %
- RProp MLP Learner< 1 %
- Logistic Regression Learner< 1 %
- Logistic Regression Predictor< 1 %
Regression Predictor< 1 %- Scorer< 1 %
- Entropy Scorer< 1 %
- Numeric Scorer< 1 %
- SVM Learner< 1 %
- Gradient Boosted Trees Learner< 1 %
Tree Ensemble Learner< 1 %- Tree Ensemble Learner< 1 %
Random Forest Learner< 1 %- Random Forest Learner (Regression)< 1 %
Random Forest Predictor< 1 %- Random Forest Predictor< 1 %
- Constant Value Row Appender< 1 %
Auto-Binner< 1 %- Bootstrap Sampling< 1 %
- Case Converter< 1 %
Cell Splitter< 1 %- Lag Column< 1 %
- Correlation Filter< 1 %
- Domain Calculator< 1 %
- Edit Nominal Domain (Dictionary)< 1 %
- Double to Integer< 1 %
Column Filter< 1 %- Filter Apply< 1 %
- Filter Apply Row Splitter< 1 %
- Row Filter (Labs)< 1 %
- Normalizer (Apply)< 1 %
- Rank< 1 %
- Number Rounder< 1 %
- Row Sampler< 1 %
- One-way ANOVA< 1 %
- CASE Switch End< 1 %
- CASE Switch Start< 1 %
- Empty Table Switch< 1 %
CASE Switch Data (End)< 1 %- Histogram (legacy)< 1 %
- Interactive Histogram (legacy)< 1 %
- Scatter Plot (legacy)< 1 %
- Scatter Matrix (legacy)< 1 %
- ROC Curve (legacy)< 1 %
- MySQL Connector< 1 %
DB Insert< 1 %DB Writer< 1 %- Random Label Assigner (Data)< 1 %
- Java Distance< 1 %
- Numeric Distances< 1 %
- String Distances< 1 %
- Matrix Distance< 1 %
- k-Medoids< 1 %
DL Network Executor< 1 %- 3D Scatter Plot (Plotly)< 1 %
- Table to PMML Ensemble< 1 %
PMML Ensemble Predictor< 1 %PMML Predictor< 1 %- Table to PDF (legacy)< 1 %
Table to PDF< 1 %- DL4J Feedforward Learner (Pretraining) (legacy)< 1 %
- DL4J Feedforward Learner (Regression) (legacy)< 1 %
- DL4J Feedforward Predictor (Regression) (legacy)< 1 %
- Table to H2O< 1 %
- Scatter Plot (JFreeChart)< 1 %
- Bubble Chart (JFreeChart)< 1 %
- Table Indexer< 1 %
- OSM Map View< 1 %
- Geo-Coordinate Row Filter< 1 %
XLS Sheet Appender< 1 %- Java Snippet Row Splitter< 1 %
- TF< 1 %
- Topic Extractor (Parallel LDA)< 1 %
- Replacer< 1 %
- Stop Word Filter< 1 %
Abner tagger< 1 %Bag of Words Creator< 1 %- Bag Of Words Creator< 1 %
- Document Vector< 1 %
- Tags to String< 1 %
- Term to String< 1 %
- Document Viewer< 1 %
- Weka Cluster Assigner (3.7)< 1 %
- External Tool (Labs)< 1 %
- Google Sheets Appender< 1 %
- Google Sheets Writer< 1 %
- Column Filter Configuration< 1 %
- Column Selection Configuration< 1 %
- Heatmap (JavaScript) (legacy)< 1 %
- Line Plot (JavaScript) (legacy)< 1 %
- Scatter Plot (JavaScript) (legacy)< 1 %
- Table Editor (JavaScript) (legacy)< 1 %
- Tag Cloud (JavaScript) (legacy)< 1 %
- Tile View (JavaScript) (legacy)< 1 %
- Value Selection Widget< 1 %
- JSON Column Combiner< 1 %
- Container Output (Table)< 1 %
- XML to JSON< 1 %
- JSON to XML< 1 %
- Max Filter< 1 %
- PNG Image to ImgPlus< 1 %
- Data Row to Image< 1 %
- Global Thresholder< 1 %
- MongoDB Writer< 1 %
- Distance Matrix to Network< 1 %
Python Script (1⇒1)< 1 %- R View (Table)< 1 %
- Table Difference Checker< 1 %
- Fail in execution< 1 %
- Legacy Date&Time to Date&Time< 1 %
Extract Date&Time Fields< 1 %- Moving Aggregator< 1 %
Time to String< 1 %- Byte Converter< 1 %
- Weak Label Model Predictor< 1 %
XGBoost Tree Ensemble Learner< 1 %- XML Column Combiner< 1 %
- Column to XML< 1 %
- XML Row Combiner< 1 %
Dumb Joiner< 1 %- Molecular Properties< 1 %
- XLogP< 1 %
- Substructure Search< 1 %
- RDKit From InChI< 1 %
- RDKit Count-Based Fingerprint< 1 %
- Corpus Creator< 1 %
- Latitude/Longitude to Coordinate< 1 %
Views
- This node has no views
Workflows
!Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub- (3D) Fragment library design workflow v1.1KNIME Hub
- [02.CX] Viber Community Report JSON Parsing WorkflowKNIME Hub
- [03] F1 - Circuit GroupingsKNIME Hub
- 0_install_AI_extensionsKNIME Hub
- Show all 746 workflows
Links
- how to merge tables, one with single instance and the other with multiple instances for a unique IDby armingrudd on 2019-09-26forum.knime.com/p/71082
- GC overhead limit exceeded while Tree Buildingby qqilihq on 2018-06-05forum.knime.com/p/43724
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.