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 Predecessors
- GroupBy7 %
Cell Splitter4 %- Create Collection Column4 %
- Column Filter4 %
- Split Collection Column3 %
- Cell Splitter2 %
- JSON Path2 %
- Joiner1 %
CSV Reader1 %Excel Reader (XLS)1 %- Association Rule Learner1 %
- Column Expressions1 %
- MzTabReader1 %
Word Vector Apply (legacy)< 1 %Column Appender< 1 %Row Filter (deprecated)< 1 %- Empty Table Switch< 1 %
Column Rename< 1 %Vocabulary Extractor (legacy)< 1 %- Variable to Table Row< 1 %
- Row Sampling< 1 %
Recursive Loop End< 1 %- Column Auto Type Cast< 1 %
- JSON to Table< 1 %
- String to JSON< 1 %
- Neo4j Reader< 1 %
- Column Rename (Regex)< 1 %
Joiner< 1 %Recursive Loop End (2 ports)< 1 %- Column Splitter< 1 %
- DL4J Feedforward Predictor (Layer) (legacy)< 1 %
- Item Set Finder (Borgelt)< 1 %
- Column Aggregator< 1 %
- Domain Calculator< 1 %
- Pivot< 1 %
- Excel Reader< 1 %
Loop End< 1 %- Extract Table Spec< 1 %
- Math Formula< 1 %
Variable to Table Row< 1 %Variable to Table Column< 1 %Table Column to Variable< 1 %Python Script (2⇒1)< 1 %- N-Gram Extractor< 1 %
- Chemical Terms< 1 %
- Table Creator< 1 %
- Group Loop Start< 1 %
- String Manipulation< 1 %
- Node Neighbor Extractor< 1 %
- Column to Grid< 1 %
- Binary Objects to Strings< 1 %
- Many to One< 1 %
Table Row To Variable Loop Start< 1 %- Cross Joiner< 1 %
- Molecular Properties< 1 %
- Fingerprint Similarity< 1 %
Table Column to Variable< 1 %- Rule Engine< 1 %
Excel Writer (XLS)< 1 %- Files/Folders Meta Info< 1 %
- Column Selection Configuration< 1 %
- Table View (JavaScript)< 1 %
File Reader< 1 %- Java Edit Variable< 1 %
- Chunk Loop Start< 1 %
- Concatenate< 1 %
Cell Replacer< 1 %- Constant Value Column< 1 %
- Missing Value< 1 %
- Sorter< 1 %
- Table Transposer< 1 %
- Ungroup< 1 %
- Rule-based Row Filter< 1 %
DL4J Feedforward Predictor (legacy)< 1 %- H2O Statistics< 1 %
- Document Vector< 1 %
- Date&Time to String< 1 %
- XPath< 1 %
- Benchmark End (Flow Variable)< 1 %
- Variable to Table Column< 1 %
- Recursive Loop Start< 1 %
- Column Appender< 1 %
- DB Reader< 1 %
- DB Looping< 1 %
- Append to Collection< 1 %
- CSV Array Reader< 1 %
- Java Snippet< 1 %
- Column List Loop Start< 1 %
- Column Combiner< 1 %
- Column Merger< 1 %
- Column Resorter< 1 %
Row Splitter (deprecated)< 1 %- Reference Row Filter< 1 %
- RowID< 1 %
- String Replacer< 1 %
- Unpivot< 1 %
- Rule-based Row Splitter< 1 %
- Cache< 1 %
- Spark to Table< 1 %
- Distance Matrix Calculate< 1 %
- Association Rule Learner (Borgelt)< 1 %
XLS Reader< 1 %- Java Snippet (simple)< 1 %
- Word Vector Apply (legacy)< 1 %
- Vocabulary Extractor (legacy)< 1 %
- Image to DataRow< 1 %
- Image Properties< 1 %
- Splitter (uncropped)< 1 %
- GET Request< 1 %
- Moving Aggregator< 1 %
- 3D RMSD< 1 %
- SMARTS Query< 1 %
- RDKit Molecule Substructure Filter< 1 %
- List To Set< 1 %
- Collection Size< 1 %
- Create Bit Vector< 1 %
- Number to String< 1 %
- Duplicate Row Filter< 1 %
- IF Switch< 1 %
- Color Manager< 1 %
- Counter Generation< 1 %
DL Network Executor< 1 %- Keras Network Executor< 1 %
- TensorFlow Network Executor< 1 %
- Term Vector< 1 %
- String to Date&Time< 1 %
- BERT Embedder< 1 %
- Collection to String< 1 %
- CSV Reader< 1 %
- Table Reader< 1 %
- Loop End< 1 %
- Recursive Loop End< 1 %
- Interactive HiLite Collector< 1 %
- Python Script (legacy)< 1 %
- HTTP Result Data Extractor< 1 %
- Table Manipulator< 1 %
- Spacy Vectorizer< 1 %
- File Reader< 1 %
- Column Renamer< 1 %
- Regex Extractor< 1 %
- RDKit Salt Stripper< 1 %
Table Row to Variable< 1 %Variable Condition Loop End< 1 %- Perl Scripting< 1 %
- Add Empty Rows< 1 %
String To Number< 1 %- Reference Column Splitter< 1 %
- Shuffle< 1 %
CASE Switch Data (End)< 1 %- Extract Time Window (legacy)< 1 %
- RDKit Calculate Charges< 1 %
Line Reader< 1 %- Category to Number< 1 %
- Math Formula (Multi Column)< 1 %
- RDKit Descriptor Calculation< 1 %
- Substructure Matcher< 1 %
- MoSS< 1 %
- String Configuration< 1 %
- Shapefile Polygon Reader< 1 %
Database Connection Table Reader< 1 %Database Reader< 1 %Database Looping< 1 %- Loop End (Column Append)< 1 %
- Distance Matrix Pair Extractor< 1 %
Number To String< 1 %- Sum Formula< 1 %
Line Reader< 1 %- String to Number< 1 %
- Create Table Structure< 1 %
- Missing Value (Apply)< 1 %
- Extract Table Dimension< 1 %
Parquet Reader< 1 %- Random Item Inserter< 1 %
Extract Date&Time Fields< 1 %- Catch Errors (Data Ports)< 1 %
- Rank< 1 %
- String Manipulation (Multi Column)< 1 %
Spacy Vectorizer< 1 %- Try (Data Ports)< 1 %
Generic Loop Start< 1 %- Auto-Binner< 1 %
- Lag Column< 1 %
- Numeric Row Splitter< 1 %
- Value Counter< 1 %
- DL4J Feedforward Predictor (Classification) (legacy)< 1 %
- Java Snippet Row Filter< 1 %
- Java Snippet Row Splitter< 1 %
- Document Data Extractor< 1 %
- Strings to Document< 1 %
- Term to String< 1 %
- Labeling Properties< 1 %
Python Script (1⇒1)< 1 %- RDKit Count-Based Fingerprint< 1 %
- RDKit Fingerprint< 1 %
Loop End (3 ports)< 1 %- Combine Columns by Header< 1 %
- LibraryMCS< 1 %
Counting Loop Start< 1 %Interval Loop Start< 1 %- Case Converter< 1 %
- Double to Integer< 1 %
Document vector< 1 %- Columns to JSON< 1 %
- PNG Image to ImgPlus< 1 %
- Insert into List< 1 %
- Missing to Empty Collection< 1 %
- Extract URI Info< 1 %
- Table Row to Variable< 1 %
- Read Images< 1 %
- Feature Selection Loop Start (1:1)< 1 %
- Table Row to Variable Loop Start< 1 %
- Denormalizer< 1 %
- Table Editor (JavaScript)< 1 %
- String Widget< 1 %
- Network Analyzer< 1 %
- Python Edit Variable (legacy)< 1 %
- RDKit Substructure Counter< 1 %
Table Reader< 1 %Recursive Loop Start< 1 %- X-Partitioner< 1 %
- MDS (DistMatrix)< 1 %
Concatenate (Optional in)< 1 %- Cell Splitter By Position< 1 %
- Column Renamer (Dictionary)< 1 %
- Correlation Filter< 1 %
- Reference Column Filter< 1 %
- HiLite Row Splitter< 1 %
- Reference Row Splitter< 1 %
- Subset Matcher< 1 %
- Partitioning< 1 %
- String Splitter (Regex)< 1 %
- Set Operator< 1 %
- Renderer to Image< 1 %
- Parallel Chunk End< 1 %
- MoSS MCSS Molecule Similarity< 1 %
Excel Reader (XLS)< 1 %- Java IF (Table)< 1 %
- Category to Class< 1 %
- Document Vector Applier< 1 %
- Column Filter (legacy)< 1 %
- Image Normalizer< 1 %
- Labeling to PNG Images< 1 %
Python Script (1⇒1)< 1 %- R Snippet< 1 %
- Connectivity< 1 %
- RDKit Substructure Filter< 1 %
- MapQuest Geocoder< 1 %
- Highlighter< 1 %
- Templated Conformer Generation (RDKit)< 1 %
- Speedy SMILES De-salt< 1 %
- Speedy SMILES Strip Stereochemistry< 1 %
- Fingerprint to Set Bits List< 1 %
Flow Variable IF Switch< 1 %- Benchmark End< 1 %
- Benchmark End (Memory Monitoring)< 1 %
- Set To List< 1 %
- Load text-based files< 1 %
- Split Into Fragments< 1 %
- Fingerprint Similarity< 1 %
- Strings to Binary Objects< 1 %
Variable to Table Row< 1 %- k-Means< 1 %
- Create Byte Vector< 1 %
- Column Comparator< 1 %
- Column Name Extractor< 1 %
- One to Many< 1 %
- Equal Size Sampling< 1 %
- Filter Apply Row Splitter< 1 %
- Missing Value Column Filter< 1 %
- Reference Column Resorter< 1 %
- String Manipulation (Variable)< 1 %
- Target Shuffling< 1 %
- Top k Row Filter< 1 %
- Decision Tree to Ruleset< 1 %
- Statistics< 1 %
- HiLite Table (legacy)< 1 %
- Extract Color< 1 %
- Similarity Search< 1 %
- DL Python Network Executor< 1 %
- Variable Expressions< 1 %
- DL4J Feedforward Predictor (Regression) (legacy)< 1 %
Excel Reader (XLS)< 1 %Read Excel Sheet Names (XLS)< 1 %- Java Edit Variable (simple)< 1 %
- Tika Language Detector< 1 %
- Punctuation Erasure< 1 %
- Tika Parser< 1 %
Document Data Extractor< 1 %- Interactive Range Slider Filter Widget< 1 %
- JSON Path (Dictionary)< 1 %
JSON Reader< 1 %- Data Row to Image< 1 %
- Rotate...< 1 %
- Partition Table< 1 %
- Multiobjective Subset Selection (NSGA-II)< 1 %
- Python Source (legacy)< 1 %
- Test FileStore Column< 1 %
- Window Loop Start< 1 %
- String to Date/Time (legacy)< 1 %
- Time to String (legacy)< 1 %
- CDK to Molecule< 1 %
- RDKit From Molecule< 1 %
- RDKit Molecule Catalog Filter< 1 %
Regex Extractor< 1 %Column Distance< 1 %- String Similarity< 1 %
- Fingerprint to Binary String< 1 %
- Fingerprint to Hexadecimal String< 1 %
- Fingerprint to String< 1 %
- ECFP/FCFP< 1 %
- Regex To List< 1 %
Variable to Table Column< 1 %- File Reader (Complex Format)< 1 %
- Line Reader< 1 %
- Variable Creator< 1 %
- Counting Loop Start< 1 %
- Generic Loop Start< 1 %
- X-Aggregator< 1 %
Scorer< 1 %- Random Forest Predictor (Regression)< 1 %
- Expand Byte Vector< 1 %
- End IF< 1 %
Color Appender< 1 %- Math Formula (Variable)< 1 %
- Replacer< 1 %
- Bag Of Words Creator< 1 %
- Date&Time Configuration< 1 %
- Image Converter< 1 %
- Date&Time Difference< 1 %
- XLogP< 1 %
- RDKit Molecule Highlighting< 1 %
- RDKit Interactive Table< 1 %
RDKit Structure Normalizer< 1 %
Views
- This node has no views
Workflows
!Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub- (3D) Fragment library design workflowKNIME Hub
- [02.CX] Viber Community Report JSON Parsing WorkflowKNIME Hub
- 0_install_AI_extensionsKNIME Hub
- 00 Data GenerationKNIME Hub
- Show all 612 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.