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 Predecessors
- JSON Path12 %
- Cell Splitter10 %
- XPath3 %
- GroupBy3 %
- Column Aggregator3 %
- Column Filter2 %
- RowID2 %
- JSON to Table2 %
Row Filter (deprecated)2 %Excel Reader (XLS)1 %- Chunk Loop Start< 1 %
- Columns to Collection< 1 %
Column Splitter< 1 %Concatenate (Optional in)< 1 %- String Manipulation< 1 %
- Rule-based Row Filter< 1 %
String To Number< 1 %- Row Filter (Labs)< 1 %
File Reader< 1 %- Pivot< 1 %
- Labeling to PNG Images< 1 %
String to Date&Time< 1 %Number To String< 1 %- Color Manager< 1 %
Table Row To Variable Loop Start< 1 %- Excel Reader< 1 %
Joiner< 1 %Column Rename< 1 %XLS Reader< 1 %JSON Reader< 1 %- XML to JSON< 1 %
- End IF< 1 %
- RDKit From Molecule< 1 %
- Loop End< 1 %
- CASE Switch Start< 1 %
- Breakpoint< 1 %
- Java Snippet< 1 %
- Reference Column Filter< 1 %
- Statistics< 1 %
- Distance Matrix Calculate< 1 %
- List To Set< 1 %
- Java Snippet Row Filter< 1 %
- Binary Objects to PNGs< 1 %
- Java Edit Variable< 1 %
- Group Loop Start< 1 %
- Domain Calculator< 1 %
- Reference Row Splitter< 1 %
- Numeric Row Splitter< 1 %
- Column Appender< 1 %
- XML Row Combiner< 1 %
- DB Reader< 1 %
- JSON to XML< 1 %
- Moving Aggregator< 1 %
- Row Splitter (col+)< 1 %
- Append to Collection< 1 %
- Table Row to Variable Loop Start< 1 %
- Variable Expressions (legacy)< 1 %
- Concatenate< 1 %
- Case Converter< 1 %
- Column to Grid< 1 %
- One to Many< 1 %
- Missing Value< 1 %
- String Splitter (Regex)< 1 %
- Value Counter< 1 %
- Rule Engine< 1 %
- Rule-based Row Splitter< 1 %
- Molecule Type Cast< 1 %
- JSON Transformer< 1 %
- Templated Conformer Generation (RDKit)< 1 %
- Extract Variables (Data)< 1 %
- XML Reader< 1 %
- Counting Loop Start< 1 %
- RDKit Substructure Counter< 1 %
- Math Formula (Variable)< 1 %
- Column Renamer< 1 %
- PIA Analysis< 1 %
- Split Collection Column< 1 %
- Column List Loop Start< 1 %
Generic Loop Start< 1 %Recursive Loop End< 1 %k-Means (deprecated)< 1 %Cell Replacer< 1 %- Column Name Replacer< 1 %
- Missing Value Column Filter< 1 %
- Table Partitioner< 1 %
- Sorter< 1 %
- Ungroup< 1 %
- Unpivot< 1 %
- Association Rule Learner (Borgelt)< 1 %
Excel Reader (XLS)< 1 %- Word Vector Apply (legacy)< 1 %
- Column Filter (legacy)< 1 %
- Table View (JavaScript) (legacy)< 1 %
- POST Request< 1 %
- Collection to String< 1 %
Variable to Table Row< 1 %- Column Auto Type Cast< 1 %
- Duplicate Row Filter< 1 %
- Strings to Document< 1 %
- Date&Time-based Row Filter< 1 %
- MzTabReader< 1 %
- CSV Reader< 1 %
- Generic Loop Start< 1 %
- Variable Loop End< 1 %
- Salesforce SOQL< 1 %
- CASE Switch End< 1 %
- Get Session Data< 1 %
- Regex Substring< 1 %
- DB Looping< 1 %
- Regex Extractor< 1 %
- Binary Objects to Strings< 1 %
- Table Creator< 1 %
- Loop End (Column Append)< 1 %
Loop End< 1 %- X-Aggregator< 1 %
- Association Rule Learner< 1 %
- Column Combiner< 1 %
- Category to Number< 1 %
- Column Renamer (Dictionary)< 1 %
- Column Resorter< 1 %
Constant Value Column< 1 %- Cross Joiner< 1 %
- Nominal Value Row Filter< 1 %
- Nominal Value Row Splitter< 1 %
Row Splitter (deprecated)< 1 %- Reference Row Filter< 1 %
- Subset Matcher< 1 %
- Denormalizer< 1 %
- Rank< 1 %
- Row Sampler< 1 %
- String Replacer< 1 %
- Table Transposer< 1 %
- Empty Table Switch< 1 %
- IF Switch< 1 %
- Cache< 1 %
- Extract Table Spec< 1 %
- Parallel Chunk End< 1 %
- Counter Generation< 1 %
- One Rule Inserter< 1 %
- MoSS< 1 %
- Item Set Finder (Borgelt)< 1 %
- Math Formula< 1 %
- Java Snippet (simple)< 1 %
- Tika Language Detector< 1 %
- Document Data Extractor< 1 %
- String to JSON< 1 %
- JSON Path (Dictionary)< 1 %
- Image Properties< 1 %
- Node Neighbor Extractor< 1 %
- Partition Table< 1 %
- GET Request< 1 %
- Fingerprint Similarity< 1 %
- RDKit Molecule Substructure Filter< 1 %
- RDKit Fingerprint< 1 %
- RDKit Substructure Filter< 1 %
- N-Gram Extractor< 1 %
- HTML Parser< 1 %
- Speedy SMILES De-salt< 1 %
- Fingerprint to Set Bits List< 1 %
- Set To List< 1 %
- Number to String< 1 %
- String to Number< 1 %
- Set Operator< 1 %
- Top k Row Filter< 1 %
- Parallel Chunk Start< 1 %
- DB Query Reader< 1 %
- Column Expressions (legacy)< 1 %
- OpenBabel< 1 %
- Math Formula (Multi Column)< 1 %
Excel Reader (XLS)< 1 %- Java IF (Table)< 1 %
- Table Editor (JavaScript) (legacy)< 1 %
- JSON Column Combiner< 1 %
- JSON Row Combiner< 1 %
- Table to JSON< 1 %
- JSON Schema Validator< 1 %
- Columns to JSON< 1 %
- Image to DataRow< 1 %
- R Snippet< 1 %
Date&Time Difference< 1 %- Window Loop Start< 1 %
- 3D RMSD< 1 %
- Neo4j Reader< 1 %
Regex Extractor< 1 %- HTTP Result Data Extractor< 1 %
- Collection Size< 1 %
- Variable to Table Column< 1 %
- Table Row to Variable< 1 %
- Variable to Table Row< 1 %
- File Reader< 1 %
- Table Reader< 1 %
- Recursive Loop End< 1 %
- Recursive Loop Start< 1 %
- Joiner< 1 %
- Table Manipulator< 1 %
- Number Rounder< 1 %
- String Manipulation (Multi Column)< 1 %
- Parquet Reader< 1 %
- Parameterized DB Query Reader< 1 %
- Term Vector< 1 %
- List Files/Folders< 1 %
- JSON Reader< 1 %
- Python Script (legacy)< 1 %
- Webpage Retriever< 1 %
- Variable Condition Loop End< 1 %
- Inject Variables (Data)< 1 %
- Catch Errors (Data Ports)< 1 %
- Insert into List< 1 %
- Date&Time Part Extractor< 1 %
- Regex To List< 1 %
- RDKit Calculate Charges< 1 %
- Column to Singleton Collection< 1 %
- Extract Missing Value Cause< 1 %
- JSON Writer< 1 %
- Save Workflow< 1 %
- Constant Value Column Filter< 1 %
Variable to Table Row< 1 %Table Reader< 1 %- Normalizer< 1 %
- Benchmark End (Memory Monitoring)< 1 %
- Many to One< 1 %
- Double to Integer< 1 %
- One to Many (PMML)< 1 %
Read Excel Sheet Names (XLS)< 1 %- Java Snippet Row Splitter< 1 %
- Container Input (JSON)< 1 %
Python Script (2⇒1)< 1 %- Find Git Branches< 1 %
- Equal Size Sampling< 1 %
- Container Input (Table)< 1 %
Variable to Table Column< 1 %Database Looping< 1 %- Perl Scripting< 1 %
Cell Splitter< 1 %- Cell Splitter By Position< 1 %
- Column Merger< 1 %
CASE Switch Data (Start)< 1 %- Spark to Table< 1 %
- Network Analyzer< 1 %
- Feature Table< 1 %
- XSLT< 1 %
- RDKit Canon SMILES< 1 %
- Benchmark End< 1 %
- MolConverter< 1 %
Database Connection Table Reader< 1 %Counting Loop Start< 1 %- Rule-based Row Splitter (Dictionary)< 1 %
- SDF Extractor< 1 %
- SDF Reader< 1 %
- Term Neighborhood Extractor< 1 %
- String to Date/Time (legacy)< 1 %
- String to XML< 1 %
FreeGeoIP< 1 %- Missing to Empty Collection< 1 %
- Try (Data Ports)< 1 %
- Similarity Search< 1 %
- String to Path< 1 %
Binary Objects to Files< 1 %Scorer< 1 %- HiLite Row Splitter< 1 %
- Shuffle< 1 %
- HiLite Table (legacy)< 1 %
- Tika Parser< 1 %
Document Data Extractor< 1 %- Multiple Selections (legacy)< 1 %
Python Script (1⇒1)< 1 %- DELETE Request< 1 %
- Sum Formula< 1 %
- RDKit To Molecule< 1 %
IF Switch (Flow Variable Value)< 1 %- ARFF Reader< 1 %
Parameterized Database Query< 1 %Line Reader< 1 %List Files< 1 %- Numeric Outliers< 1 %
- Extract Table Dimension< 1 %
- PDF Parser< 1 %
- Python Source (legacy)< 1 %
- Get Git Commit Details< 1 %
UNIX Timestamp to Date&Time< 1 %- Table to HTML String< 1 %
- Molecular Properties< 1 %
- RDKit Molecule Catalog Filter< 1 %
- RDKit Molecule Fragmenter< 1 %
- Molecule Properties< 1 %
- Table Column to Variable< 1 %
- File Reader (Complex Format)< 1 %
- Linear Correlation< 1 %
- Row Splitter (Labs)< 1 %
- Reference Column Resorter< 1 %
- Data Explorer< 1 %
DB Writer< 1 %- Read Excel Sheet Names< 1 %
- Meta Info Extractor< 1 %
- String to Path (Variable)< 1 %
- Polygon Properties< 1 %
Table Column to Variable< 1 %CSV Reader< 1 %Database Reader< 1 %Loop End (2 ports)< 1 %Variable Condition Loop End< 1 %Recursive Loop End (2 ports)< 1 %Recursive Loop Start< 1 %Naive Bayes Predictor< 1 %- DBSCAN< 1 %
- Expand Bit Vector< 1 %
Column Appender< 1 %- Lag Column< 1 %
- Conditional Box Plot (legacy)< 1 %
- DL4J Feedforward Predictor (Layer) (legacy)< 1 %
- IDF< 1 %
- Punctuation Erasure< 1 %
Document vector< 1 %Strings To Document< 1 %- Term to String< 1 %
- Scatter Plot (JavaScript) (legacy)< 1 %
- Splitter (uncropped)< 1 %
Python Script (1⇒1)< 1 %- Date Field Extractor (legacy)< 1 %
- Twitter Users (legacy)< 1 %
XML Reader< 1 %- RDKit Diversity Picker< 1 %
- FileToTable< 1 %
- Fingerprint to Binary String< 1 %
IF Switch (Flow Variable Value)< 1 %Flow Variable IF Switch< 1 %- Chunk Loop Run-for-time Loop Start< 1 %
- Naming< 1 %
- Split Into Fragments< 1 %
Unzip Files< 1 %- URL to File Path (Variable)< 1 %
- Wait...< 1 %
Table Row to Variable< 1 %- Fixed Width File Reader< 1 %
Variable Loop End< 1 %- Naive Bayes Learner< 1 %
- Fuzzy Rule Learner< 1 %
- Hierarchical Clustering< 1 %
- Hierarchical Cluster Assigner (local)< 1 %
PCA< 1 %- Column Comparator< 1 %
- Table Validator< 1 %
- Filter Apply< 1 %
- Column Filter (PMML)< 1 %
- String Manipulation (Variable)< 1 %
- Rule Engine Variable< 1 %
- Rule Engine (Dictionary)< 1 %
- Standardized Cronbach Alpha< 1 %
- Crosstab< 1 %
- One Row to Many< 1 %
- Random Item Inserter< 1 %
- Stresser< 1 %
- Geo-Coordinate Row Filter< 1 %
- Radar Plot Appender< 1 %
- Frequency Filter< 1 %
- RegEx Filter< 1 %
- Snowball Stemmer< 1 %
- StanfordNLP NE Tagger< 1 %
- Document Vector< 1 %
- Document Vector Applier< 1 %
- String to Term< 1 %
- Google Sheets Reader< 1 %
- Double Configuration< 1 %
- File Chooser (legacy)< 1 %
- Slider Input (legacy)< 1 %
- Image Resizer< 1 %
- Multiobjective Subset Selection (NSGA-II)< 1 %
Python Source< 1 %Python Script (2⇒2)< 1 %- Test Data Generator< 1 %
Date&Time to String< 1 %Extract Date&Time Fields< 1 %Modify Date< 1 %- XML Column Combiner< 1 %
- Column to XML< 1 %
- SMARTS Query< 1 %
- MapQuest Geocoder< 1 %
- HTML Node to Text< 1 %
- RMSD Conformer List Filter< 1 %
- Run Garbage Collector< 1 %
- PDB Property Extractor< 1 %
Variable to Table Column< 1 %- Read Images< 1 %
CSV Writer< 1 %- CSV Writer< 1 %
Recursive Loop Start (2 ports)< 1 %Auto-Binner< 1 %- Nominal Probability Distribution Creator< 1 %
CASE Switch Data (End)< 1 %Parquet Reader< 1 %- Topic Extractor (Parallel LDA)< 1 %
- N Chars Filter< 1 %
- Create File/Folder Variables< 1 %
- Date&Time Configuration< 1 %
- Scorer (JavaScript)< 1 %
- Interactive Value Filter Widget< 1 %
- Nominal Row Filter Widget< 1 %
- List Box Widget< 1 %
- MongoDB Connector< 1 %
- MongoDB Reader< 1 %
- Salesforce Simple Query< 1 %
- RDKit Descriptor Calculation< 1 %
Views
- This node has no views
Workflows
!Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub- 0_install_AI_extensionsKNIME Hub
- 00_bindingsiteexplorationKNIME Hub
- 00_Topic_Modeling_with_Verified_ComponentsKNIME Hub
- 00_Topic_Modeling_with_Verified_ComponentsKNIME Hub
- Show all 2743 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.