Creates for each list of collection values a list of rows with the values of the collection in one column and all other columns given from the original row. Rows with an empty collection are skipped, as well as rows that contain only missing values in the collection cell with the 'Skip missing values' option enabled.
Options
Popular Successors
- Joiner7 %
- GroupBy7 %
- JSON Path6 %
Row Filter (deprecated)6 %- Column Filter6 %
- JSON to Table4 %
- String Manipulation3 %
- Duplicate Row Filter2 %
- Excel Writer2 %
- Rule-based Row Filter2 %
Column Rename2 %- Cell Splitter1 %
- Column Expressions1 %
- Sorter1 %
- Ungroup1 %
- Concatenate1 %
- Rule Engine1 %
- Loop End< 1 %
Row Splitter (deprecated)< 1 %- Reference Row Filter< 1 %
- XPath< 1 %
- Missing Value< 1 %
- String to Number< 1 %
- Column Renamer< 1 %
- Constant Value Column< 1 %
- CSV Writer< 1 %
- Rule-based Row Splitter< 1 %
- RowID< 1 %
- Chunk Loop Start< 1 %
- Table Manipulator< 1 %
- Pivot< 1 %
- Math Formula< 1 %
- String to Date&Time< 1 %
- Java Snippet< 1 %
Number To String< 1 %- Table Transposer< 1 %
- Unpivot< 1 %
Table Row to Variable< 1 %Database Looping< 1 %- Cross Joiner< 1 %
Joiner< 1 %XLS Writer< 1 %- Reference Row Splitter< 1 %
- Table View (JavaScript)< 1 %
- Column List Loop Start< 1 %
- Group Loop Start< 1 %
- Table Row to Variable Loop Start< 1 %
- Column Aggregator< 1 %
- Column Splitter< 1 %
- String Manipulation (Multi Column)< 1 %
- CASE Switch End< 1 %
- CASE Switch Start< 1 %
- Column Rename (Regex)< 1 %
- Molecule Type Cast< 1 %
- JSON Row Combiner and Writer< 1 %
- URL to File Path< 1 %
Table Row To Variable Loop Start< 1 %- Interactive Table (legacy)< 1 %
- Recursive Loop End< 1 %
- Regex Extractor< 1 %
Table Column to Variable< 1 %Table Row to Variable< 1 %Table Writer< 1 %- Constant Value Column Filter< 1 %
- IF Switch< 1 %
- Table View< 1 %
- String to JSON< 1 %
- Object Inserter< 1 %
- ZXing Decoder< 1 %
- Table to Image< 1 %
- Variable Condition Loop End< 1 %
- Column Comparator< 1 %
- Lag Column< 1 %
- Column Resorter< 1 %
- Histogram (legacy)< 1 %
- DB Writer< 1 %
- Variable Expressions< 1 %
- RDKit Fingerprint< 1 %
- String Similarity< 1 %
- Active Branch Inverter< 1 %
Recursive Loop Start< 1 %- Column Appender< 1 %
- Filter Apply Row Splitter< 1 %
- Rule Engine (Dictionary)< 1 %
- Cache< 1 %
- Bar Chart< 1 %
- Java Snippet Row Splitter< 1 %
Strings To Document< 1 %- Path to String< 1 %
- String to Path< 1 %
- Table to JSON< 1 %
- JSON Schema Validator< 1 %
JSON Writer< 1 %XPath< 1 %- Benchmark End< 1 %
CSV Writer< 1 %Counting Loop Start< 1 %- Number to String< 1 %
- Rank< 1 %
- String Manipulation (Variable)< 1 %
- String Replacer< 1 %
- Empty Table Switch< 1 %
- Extract Table Spec< 1 %
- Line Plot (legacy)< 1 %
- Line Plot (Plotly)< 1 %
- String Matcher< 1 %
- Tag Cloud (JavaScript)< 1 %
- SubGraph Extractor< 1 %
- GET Request< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Moving Aggregator< 1 %
- XLS Control Table Generator< 1 %
- MarvinView< 1 %
Database Writer< 1 %- Random Forest Predictor< 1 %
- Column Combiner< 1 %
- Category to Number< 1 %
- Column Merger< 1 %
- String Splitter (Regex)< 1 %
- Rule-based Row Splitter (Dictionary)< 1 %
- Box Plot< 1 %
- DB Insert< 1 %
- Parameterized DB Query Reader< 1 %
- Counter Generation< 1 %
- Create Temp Folder< 1 %
- Google Sheets Updater< 1 %
MongoDB Writer< 1 %- MongoDB Connector< 1 %
- Split Collection Column< 1 %
- Table Row to Variable< 1 %
Database Table Creator< 1 %- Generic Loop Start< 1 %
- Recursive Loop Start< 1 %
Scorer< 1 %- Add Empty Rows< 1 %
- Create Bit Vector< 1 %
- Cell Splitter By Position< 1 %
- Column Auto Type Cast< 1 %
- One to Many< 1 %
- Domain Calculator< 1 %
- Row Splitter (Labs)< 1 %
- Subset Matcher< 1 %
- Number Rounder< 1 %
- Numeric Row Splitter< 1 %
- Row to Column Names< 1 %
- Set Operator< 1 %
- Value Lookup< 1 %
- Pie Chart< 1 %
- Parallel Chunk Start< 1 %
- DB Looping< 1 %
- One Row to Many< 1 %
- Java Snippet (simple)< 1 %
- Java IF (Table)< 1 %
- Markup Tag Filter< 1 %
- Tika Language Detector< 1 %
- Column Filter (legacy)< 1 %
- Interactive Range Slider Filter Widget< 1 %
- Interactive Value Filter Widget< 1 %
- JSON Column Combiner< 1 %
- JSON Path (Dictionary)< 1 %
- Kafka Producer< 1 %
- R View (Table)< 1 %
- POST Request< 1 %
Extract Date&Time Fields< 1 %- Neo4j Reader< 1 %
- HTTP Retriever< 1 %
- HTML Parser< 1 %
- InChi< 1 %
- Run Garbage Collector< 1 %
- 1D Kernel Density Plot< 1 %
- Collection to String< 1 %
- URL Decode< 1 %
Element Selector< 1 %- Create Collection Column< 1 %
- PNGs to Binary Objects< 1 %
- Breakpoint< 1 %
- Catch Errors (Data Ports)< 1 %
- Variable to Table Column< 1 %
- Table Column to Variable< 1 %
- Read Images< 1 %
Parameterized Database Query< 1 %- Table Writer< 1 %
- Loop End (Column Append)< 1 %
Loop End< 1 %Recursive Loop End< 1 %- Auto-Binner< 1 %
- Bootstrap Sampling< 1 %
- Case Converter< 1 %
Cell Replacer< 1 %- Column Name Extractor< 1 %
- Column Renamer (Dictionary)< 1 %
- Column to Grid< 1 %
- Table Validator (Reference)< 1 %
- Reference Column Filter< 1 %
- Missing Value Column Filter< 1 %
- Nominal Value Row Filter< 1 %
- Nominal Value Row Splitter< 1 %
- Row Filter (Labs)< 1 %
- Normalizer< 1 %
- Partitioning< 1 %
- Row Aggregator< 1 %
- Row Sampling< 1 %
- Shuffle< 1 %
- Table Difference Finder< 1 %
- Top k Row Filter< 1 %
- Value Counter< 1 %
- Renderer to Image< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Shapiro-Wilk Test< 1 %
- Statistics< 1 %
- End IF< 1 %
- Extract Table Dimension< 1 %
- Crosstab< 1 %
- Lift Chart (legacy)< 1 %
- Color Manager< 1 %
- Scatter Plot< 1 %
- SDF Writer< 1 %
- Parallel Chunk End< 1 %
- DB Merge< 1 %
- DB Table Creator< 1 %
- Similarity Search< 1 %
- 3D Scatter Plot (Plotly)< 1 %
- Bar Chart (JavaScript)< 1 %
- Scatter Plot (Plotly)< 1 %
Table to PDF< 1 %- Association Rule Learner (Borgelt)< 1 %
- Math Formula (Multi Column)< 1 %
- Geo-Coordinate Row Filter< 1 %
Excel Writer (XLS)< 1 %- Send to Tableau Server< 1 %
- Stop Word Filter< 1 %
- Strings to Document< 1 %
- String to Term< 1 %
- Column Filter Configuration< 1 %
- Generic JavaScript View (JavaScript)< 1 %
- Line Plot (JavaScript)< 1 %
- Scatter Plot (JavaScript)< 1 %
- Nominal Row Filter Widget< 1 %
- Value Selection Widget< 1 %
- JSON Row Combiner< 1 %
- JSON Writer< 1 %
- JSON Transformer< 1 %
- Columns to JSON< 1 %
- JSON to XML< 1 %
- MongoDB Writer< 1 %
- Python Script (legacy)< 1 %
- Python View (legacy)< 1 %
- Table to R< 1 %
- Data to Report (BIRT)< 1 %
- Webpage Retriever< 1 %
- Date&Time Difference< 1 %
- Date&Time Shift< 1 %
- XML Row Combine and Write< 1 %
- String to XML< 1 %
- Molecular Properties< 1 %
- RDKit Canon SMILES< 1 %
- RDKit From InChI< 1 %
- RDKit From Molecule< 1 %
- RDKit Substructure Filter< 1 %
- Neo4j Writer< 1 %
Regex Extractor< 1 %- Canonical SMILES< 1 %
IF Switch (Flow Variable Value)< 1 %- Binary Objects to PNGs< 1 %
Variable to Table Column< 1 %Image Writer (Table Column)< 1 %Database Drop Table< 1 %- Java Edit Variable< 1 %
- Cluster Assigner< 1 %
- Linear Regression Learner< 1 %
- Random Forest Learner< 1 %
String Replace (Dictionary)< 1 %- Independent groups t-test< 1 %
CASE Switch Data (End)< 1 %- Matrix Distance< 1 %
- Violin Plot (Plotly)< 1 %
- External Tool< 1 %
- OSM Map View< 1 %
- ROC Curve (JavaScript)< 1 %
Python Script (1⇒1)< 1 %- PUT Request< 1 %
- Table Difference Checker< 1 %
- RDKit Open 3D Alignment< 1 %
- RDKit To InChI< 1 %
- Range Splitter< 1 %
- Try (Data Ports)< 1 %
- Extract Variables (Data)< 1 %
- Inject Variables (Data)< 1 %
Table Column to Variable< 1 %CSV Reader< 1 %List Files< 1 %Loop End (2 ports)< 1 %Interval Loop Start< 1 %- Hierarchical Clustering (DistMatrix)< 1 %
- Decision Tree Learner< 1 %
- Regression Predictor< 1 %
- Association Rule Learner< 1 %
- PCA Apply< 1 %
- Column Filter (PMML)< 1 %
- Rule Engine Variable< 1 %
- Paired t-test< 1 %
- Timer Info< 1 %
- Interactive Histogram (legacy)< 1 %
- Box Plot (legacy)< 1 %
- Shape Manager< 1 %
Parquet Writer< 1 %- DB Update< 1 %
- Random Number Assigner< 1 %
- String Distances< 1 %
- Keras Network Learner< 1 %
- Table to HTML (legacy)< 1 %
- GroupBy Bar Chart (JFreeChart)< 1 %
Excel Sheet Appender (XLS)< 1 %Excel Writer (XLS)< 1 %- Doc2Vec Learner (legacy)< 1 %
- Dictionary Tagger< 1 %
- Bag Of Words Creator< 1 %
- Nominal Row Filter Configuration< 1 %
JSON Path< 1 %Python Script (2⇒1)< 1 %- Date&Time Part Extractor< 1 %
- Date&Time-based Row Filter< 1 %
- Time Field Extractor (legacy)< 1 %
- String to Date/Time (legacy)< 1 %
- Row Splitter (col+)< 1 %
Reverse Location Lookup< 1 %- CIR< 1 %
- IL XLS Writer< 1 %
- Reference Fragments to MMPs< 1 %
- JC4XL Writer< 1 %
- Strings to Binary Objects< 1 %
- Upload (legacy)< 1 %
Variable to Table Column< 1 %- Create File Name (legacy)< 1 %
Variable to Table Row< 1 %- Perl Scripting< 1 %
Concatenate (Optional in)< 1 %Cell Splitter< 1 %String To Number< 1 %- String to SVG< 1 %
- Edit Nominal Domain< 1 %
- Double to Integer< 1 %
- One to Many (PMML)< 1 %
- Rule Engine Variable (Dictionary)< 1 %
- One-way ANOVA< 1 %
Hive Loader (legacy)< 1 %DB Table Creator< 1 %PMML Predictor< 1 %Table to HTML< 1 %- Pie Chart (JFreeChart)< 1 %
TIBCO File Writer< 1 %- Radar Plot Appender< 1 %
- Topic Extractor (Parallel LDA)< 1 %
Stop Word Filter< 1 %- Value Selection Configuration< 1 %
- Value Filter (legacy)< 1 %
- Apply Color Settings To Labels< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Modify Time< 1 %
- Date/Time Shift (legacy)< 1 %
- Date Field Extractor (legacy)< 1 %
- Column to XML< 1 %
- XML Row Combiner< 1 %
- Atom Signatures< 1 %
- Fingerprints< 1 %
- Fingerprint Similarity< 1 %
- RDKit Descriptor Calculation< 1 %
- RDKit Molecule Highlighting< 1 %
- RDKit One Component Reaction< 1 %
- Text Classifier Learner< 1 %
- Geo Distances< 1 %
- N-Gram Extractor< 1 %
- HTML Node to Text< 1 %
- XLS Control Table from Cell Range< 1 %
- Reaxys Substances< 1 %
- Component Combiner< 1 %
- Highlighter< 1 %
- Molecule Properties< 1 %
- Substructure Matcher< 1 %
PMI Calculation< 1 %- Speedy SMILES Heavy Atom Count (HAC)< 1 %
- Apply Transforms (RDKit) (Experimental)< 1 %
- Distance (2-D)< 1 %
- Distance (3-D)< 1 %
- Number Formatter< 1 %
- Binning Calculate< 1 %
- Group Mutual Information< 1 %
- Matlab Snippet< 1 %
- Standardizer< 1 %
- String to Table< 1 %
Active Learn Loop Start< 1 %- Copy/Move Files (legacy)< 1 %
- String to URI< 1 %
- URI to String< 1 %
- Wait...< 1 %
Database Table Connector< 1 %Database Reader< 1 %- File Reader< 1 %
- Image Writer (Table)< 1 %
Variable Condition Loop End< 1 %Generic Loop Start< 1 %Recursive Loop End (2 ports)< 1 %Recursive Loop Start (2 ports)< 1 %- Variable Loop End< 1 %
Variable Loop End< 1 %- X-Partitioner< 1 %
- Fuzzy c-Means< 1 %
- k-Means< 1 %
- Decision Tree to Image< 1 %
PCA Compute< 1 %- SVM Learner< 1 %
Gradient Boosted Trees Learner< 1 %- Distance Matrix Pair Extractor< 1 %
- Numeric Binner< 1 %
- Binner (Dictionary)< 1 %
- Number to Category (Apply)< 1 %
Column Appender< 1 %- Many to One< 1 %
Linear Correlation< 1 %- Linear Correlation< 1 %
- Table Validator< 1 %
- Edit Nominal Domain (Dictionary)< 1 %
- Edit Numeric Domain< 1 %
- Equal Size Sampling< 1 %
- Reference Column Splitter< 1 %
- Filter Apply< 1 %
- HiLite Row Splitter< 1 %
- Normalizer (Apply)< 1 %
- Denormalizer< 1 %
- Many to One (PMML)< 1 %
- Missing Value (Apply)< 1 %
- Normalizer (PMML)< 1 %
- Number to String (PMML)< 1 %
- XML to PMML< 1 %
- Reference Column Resorter< 1 %
- Data Explorer< 1 %
CASE Switch Data (Start)< 1 %- Merge Variables< 1 %
Merge Variables< 1 %- Interactive Pie chart (legacy)< 1 %
- Parallel Coordinates (legacy)< 1 %
- Scatter Plot (legacy)< 1 %
- Scatter Matrix (legacy)< 1 %
- Size Manager< 1 %
- ROC Curve (legacy)< 1 %
- HDFS File Permission (legacy)< 1 %
- Table to Spark< 1 %
- Amazon Authenticator< 1 %
MySQL Connector< 1 %- DB Connector< 1 %
- DB Query Reader< 1 %
- Random Matcher< 1 %
- Numeric Distances< 1 %
- Distance Matrix Calculate< 1 %
- Autocomplete Text Widget< 1 %
- Bubble Chart (Plotly)< 1 %
- Parallel Coordinates Plot (JavaScript)< 1 %
- Table to PDF (legacy)< 1 %
- OpenBabel< 1 %
DL4J Feedforward Learner (legacy)< 1 %- Item Set Finder (Borgelt)< 1 %
- Bar Chart (JFreeChart)< 1 %
- Histogram Chart (JFreeChart)< 1 %
- Line Chart (JFreeChart)< 1 %
- Scatter Plot (JFreeChart)< 1 %
- Bubble Chart (JFreeChart)< 1 %
- JPython Script 1:1 (Legacy)< 1 %
- JPython Script 2:1 (Legacy)< 1 %
- Table Indexer< 1 %
Excel Reader (XLS)< 1 %Excel Sheet Appender (XLS)< 1 %- Java Snippet Row Filter< 1 %
Send to Tableau Server (Hyper)< 1 %Tableau Writer (Hyper)< 1 %Tableau Writer (TDE)< 1 %- Term Co-Occurrence Counter< 1 %
- TF< 1 %
- Case Converter< 1 %
- Dictionary Filter< 1 %
- Punctuation Erasure< 1 %
- RegEx Filter< 1 %
- Dictionary Tagger (Multi Column)< 1 %
- OpenNLP NE Tagger< 1 %
- Document Data Extractor< 1 %
- Document Vector Hashing< 1 %
- Term to String< 1 %
- Tag Cloud< 1 %
- Weka Predictor (3.7)< 1 %
- GeoJSON writer< 1 %
- Google Analytics Query (legacy)< 1 %
- Google Sheets Appender< 1 %
- Google Sheets Writer< 1 %
- Range Slider Filter Definition (legacy)< 1 %
- Value Selection (legacy)< 1 %
- Heatmap (JavaScript)< 1 %
- Table Editor (JavaScript)< 1 %
- Column Selection Widget< 1 %
- Container Input (Table)< 1 %
- Container Output (Table)< 1 %
- XML to JSON< 1 %
- Container Output (JSON)< 1 %
- JSON Diff< 1 %
- Image Properties< 1 %
- Image Converter< 1 %
- Multi Feature Inserter< 1 %
- Distance Matrix to Network< 1 %
- Feature Table< 1 %
- Matrix to Network< 1 %
- Network Viewer< 1 %
Python View< 1 %Python Script (1⇒1)< 1 %- R Snippet< 1 %
- DELETE Request< 1 %
- Date&Time to String< 1 %
- Modify Date< 1 %
- Modify Time Zone< 1 %
- Window Loop Start< 1 %
- Time to String (legacy)< 1 %
- Twitter Retweet Search< 1 %
- XSLT< 1 %
- Table to HTML String< 1 %
- 3D D-Similarity< 1 %
- 3D Viewer< 1 %
- RDKit Interactive Table< 1 %
- RDKit MCS< 1 %
- RDKit Molecule Substructure Filter< 1 %
- RDKit To Molecule< 1 %
- RDKit R-Group Decomposition (deprecated)< 1 %
Map Viewer< 1 %- Base64 Decoder< 1 %
- URL Domain Extractor< 1 %
HTTP Retriever< 1 %
Views
- This node has no views
Workflows
!Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub- 0_install_AI_extensionsKNIME Hub
- 0. TemplatesKNIME Hub
- 00_Topic_Modeling_with_Verified_ComponentsKNIME Hub
- 00_Topic_Modeling_with_Verified_ComponentsKNIME Hub
- Show all 1983 workflows
Links
- How to split a multirow string in different rows?by qqilihq on 2019-12-11forum.knime.com/p/76741
- Compare Two Sets [Arrays]by AnotherFraudUser on 2020-05-17forum.knime.com/p/91527
- Get lines from PDF Fileby armingrudd on 2020-01-08forum.knime.com/p/78256
- Separate a JSON array and doing multiple POST Requestsby armingrudd on 2020-04-22forum.knime.com/p/88606
- Unpivoting Multiple Columnsby armingrudd on 2019-10-29forum.knime.com/p/73571
- Show all 11 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.