This node splits the columns of the input table into two output tables. Specify in the dialog which columns should occur in the top table (left list), and the bottom table (right list). Use the buttons to move columns from one list to the other.
Options
Manual Selection
Wildcard/Regex Selection
Type Selection
Popular Predecessors
- Excel Reader3 %
Row Filter (deprecated)3 %- Column Filter3 %
Row Splitter (deprecated)2 %String To Number2 %- CSV Reader2 %
- Column Splitter2 %
Column Rename2 %- Column Resorter2 %
- Rule Engine2 %
- Concatenate1 %
- GroupBy1 %
- String Manipulation1 %
- Missing Value1 %
- Cell Splitter1 %
XLS Reader1 %- Math Formula1 %
- Duplicate Row Filter1 %
- Rule-based Row Filter1 %
- Column Expressions1 %
Excel Reader (XLS)1 %- String to Number1 %
Line Reader< 1 %- Nominal Value Row Filter< 1 %
- RowID< 1 %
- Column Appender< 1 %
- Sorter< 1 %
- File Reader< 1 %
- Chunk Loop Start< 1 %
Table Row to Variable< 1 %- Rule-based Row Splitter< 1 %
Concatenate (Optional in)< 1 %PCA Compute< 1 %- Parameter Optimization Loop Start< 1 %
List Files< 1 %- Column List Loop Start< 1 %
- String Manipulation (Multi Column)< 1 %
- Column Renamer< 1 %
- Column Merger< 1 %
- Constant Value Column< 1 %
- Normalizer (Apply)< 1 %
- Pivot< 1 %
- ARFF Reader< 1 %
- Table Creator< 1 %
Variable to Table Column< 1 %- Group Loop Start< 1 %
- Column Aggregator< 1 %
- Table Transposer< 1 %
- Weka Predictor (3.7)< 1 %
- JSON Path< 1 %
- Loop End< 1 %
- Column Combiner< 1 %
- Column Selection (legacy)< 1 %
- String to Date&Time< 1 %
Table Row To Variable Loop Start< 1 %Variable to Table Row< 1 %Scorer< 1 %- Unpivot< 1 %
- Number to String< 1 %
- RDKit Canon SMILES< 1 %
- Java Snippet (simple)< 1 %
- Loop End (Column Append)< 1 %
- Column Comparator< 1 %
- GET Request< 1 %
- HTTP Result Data Extractor< 1 %
- PCA< 1 %
- Table Row to Variable Loop Start< 1 %
- Ungroup< 1 %
- String to XML< 1 %
- String Similarity< 1 %
Interval Loop Start< 1 %Naive Bayes Predictor< 1 %- XPath< 1 %
- DB Query Reader< 1 %
- Table Reader< 1 %
- Column Rename (Regex)< 1 %
- Normalizer< 1 %
String Replace (Dictionary)< 1 %- JSON to Table< 1 %
- Tika Parser< 1 %
- Breakpoint< 1 %
- Inject Variables (Data)< 1 %
CSV Reader< 1 %- Reference Row Splitter< 1 %
- Linear Regression Learner< 1 %
Table Column to Variable< 1 %Generic Loop Start< 1 %- Cell Splitter By Position< 1 %
- Reference Column Filter< 1 %
- Denormalizer< 1 %
- Partitioning< 1 %
- Number Rounder< 1 %
- Row Sampling< 1 %
- String Manipulation (Variable)< 1 %
- End IF< 1 %
- Box Plot (legacy)< 1 %
- Save Workflow< 1 %
- SDF Reader< 1 %
- Math Formula (Multi Column)< 1 %
- Date&Time to legacy Date&Time< 1 %
- PCA Compute< 1 %
IF Switch (Flow Variable Value)< 1 %- Java Edit Variable< 1 %
PCA< 1 %- SMOTE< 1 %
- Reference Row Filter< 1 %
- Rule Engine Variable< 1 %
CASE Switch Data (End)< 1 %- Word Vector Apply (legacy)< 1 %
- Strings to Document< 1 %
- R Predictor< 1 %
- Moving Average< 1 %
- Parallel Chunk End< 1 %
- Generic Loop Start< 1 %
- Catch Errors (Data Ports)< 1 %
Table Writer< 1 %Counting Loop Start< 1 %- k-Means< 1 %
- Expand Bit Vector< 1 %
- Column Auto Type Cast< 1 %
Linear Correlation< 1 %- Correlation Filter< 1 %
- Reference Column Splitter< 1 %
- Missing Value Column Filter< 1 %
- Missing Value (Apply)< 1 %
- Shuffle< 1 %
- String Replacer< 1 %
- Extract Table Spec< 1 %
- Column Filter (legacy)< 1 %
- Container Input (Table)< 1 %
- Mask Date/Time (legacy)< 1 %
- RDKit To Molecule< 1 %
- Automated Matched Pairs< 1 %
- URL to File Path< 1 %
- Word Parser< 1 %
- Row Splitter (Labs)< 1 %
- Workflow Service Input< 1 %
- Row to Column Names< 1 %
- CDK to Molecule< 1 %
Table Reader< 1 %Regression Predictor< 1 %- Add Empty Rows< 1 %
- Numeric Binner< 1 %
Column Appender< 1 %- Column Renamer (Dictionary)< 1 %
- Equal Size Sampling< 1 %
- Low Variance Filter< 1 %
- SDF Extractor< 1 %
- Parallel Chunk Start< 1 %
- Weka Cluster Assigner (3.7)< 1 %
- Modify Date< 1 %
- Date Field Extractor (legacy)< 1 %
Variable to Table Row< 1 %- Hierarchical Clustering< 1 %
- Random Forest Predictor< 1 %
- Top k Row Filter< 1 %
- DB Reader< 1 %
Excel Reader (XLS)< 1 %- Parameter Optimization Loop End< 1 %
- Variable to Table Row< 1 %
- Line Reader< 1 %
- Joiner< 1 %
- List Files/Folders< 1 %
- Refresh Button Widget< 1 %
- SDF Reader< 1 %
- Feature Selection Loop End< 1 %
Recursive Loop Start< 1 %- Fuzzy c-Means< 1 %
K Nearest Neighbor< 1 %- Case Converter< 1 %
- Cross Joiner< 1 %
- Table Validator< 1 %
- Double to Integer< 1 %
- Extract Missing Value Cause< 1 %
- String Splitter (Regex)< 1 %
- Empty Table Switch< 1 %
- Cache< 1 %
- Color Manager< 1 %
- Google Sheets Reader< 1 %
- Date&Time to String< 1 %
- Moving Aggregator< 1 %
- Molecule to CDK< 1 %
- RDKit From Molecule< 1 %
- Logistic Regression Predictor< 1 %
- Regression Predictor< 1 %
- PCA Apply< 1 %
- Gradient Boosted Trees Predictor (Regression)< 1 %
- Tree Ensemble Predictor< 1 %
- Row Filter (Labs)< 1 %
Column Selection Configuration< 1 %- Window Loop Start< 1 %
- Substructure Search< 1 %
- Table Column to Variable< 1 %
- File Reader (Complex Format)< 1 %
- Variable Loop End< 1 %
- Table Difference Finder< 1 %
- CASE Switch Start< 1 %
- Read Excel Sheet Names< 1 %
- Configurable IF/CASE Switch (Flow Variable Value)< 1 %
- Standardizer< 1 %
- Number Formatter< 1 %
- Advanced MolConverter< 1 %
- Create Collection Column< 1 %
- Split Collection Column< 1 %
- Wait...< 1 %
File Reader< 1 %- Java Snippet< 1 %
Loop End (2 ports)< 1 %Loop End< 1 %Recursive Loop Start (2 ports)< 1 %- X-Partitioner< 1 %
- DBSCAN< 1 %
- Decision Tree Predictor< 1 %
- MultiLayerPerceptron Predictor< 1 %
PCA Apply< 1 %- Association Rule Learner< 1 %
Random Forest Predictor (Regression)< 1 %- Random Forest Predictor (Regression)< 1 %
- Auto-Binner< 1 %
Cell Replacer< 1 %- Category to Number< 1 %
- Column Name Extractor< 1 %
- Lag Column< 1 %
- Column to Grid< 1 %
- One to Many< 1 %
- Nominal Value Row Splitter< 1 %
Joiner< 1 %- Rank< 1 %
- Reference Column Resorter< 1 %
- Numeric Row Splitter< 1 %
- Value Counter< 1 %
- Data Explorer< 1 %
- Numeric Outliers< 1 %
- Statistics< 1 %
- IF Switch< 1 %
- Timer Info< 1 %
- ROC Curve (legacy)< 1 %
- Molecule Type Cast< 1 %
- Counter Generation< 1 %
- Math Formula (Variable)< 1 %
Excel Reader (XLS)< 1 %- Java Edit Variable (simple)< 1 %
- POST Request< 1 %
- Test Data Generator< 1 %
- Date&Time Difference< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Date&Time-based Row Filter< 1 %
- Twitter Search< 1 %
- RDKit Molecule Substructure Filter< 1 %
- Duplicate Remover< 1 %
- Collection to String< 1 %
- Collection Size< 1 %
- Binary Objects to Strings< 1 %
- Extract URI Info< 1 %
- Files to Binary Objects< 1 %
- Feature Selection Loop Start (1:1)< 1 %
- K Nearest Neighbor< 1 %
- SVM Predictor< 1 %
- Gradient Boosted Trees Predictor< 1 %
- Bootstrap Sampling< 1 %
- Table Validator (Reference)< 1 %
- Constant Value Column Filter< 1 %
- Renderer to Image< 1 %
- Merge Variables< 1 %
- Data Generator< 1 %
Color Appender< 1 %- DB Insert< 1 %
- DB Merge< 1 %
- Similarity Search< 1 %
- Variable Expressions< 1 %
Read Excel Sheet Names (XLS)< 1 %- Java IF (Table)< 1 %
- PDF Parser< 1 %
- Document Data Extractor< 1 %
- Nominal Row Filter Configuration< 1 %
- Column Selection Configuration< 1 %
- Table View (JavaScript)< 1 %
- XML to JSON< 1 %
- RDKit Descriptor Calculation< 1 %
- RDKit R-Group Decomposition (deprecated)< 1 %
- Load Text Files< 1 %
- Variable to Table Column< 1 %
- Table Row to Variable< 1 %
- Variable Creator< 1 %
- Counting Loop Start< 1 %
- Recursive Loop End< 1 %
- Recursive Loop Start< 1 %
- Table Manipulator< 1 %
- Path to String< 1 %
- String to Path< 1 %
- Column Filter Configuration< 1 %
- String Configuration< 1 %
- Python Script (legacy)< 1 %
- Date&Time Part Extractor< 1 %
Regex Extractor< 1 %- String Matcher< 1 %
- RDKit Two Component Reaction< 1 %
- Column Filter Widget< 1 %
- Files/Folders Meta Info< 1 %
- CASE Switch End< 1 %
- SharePoint Online List Reader< 1 %
- Create Date&Time Range< 1 %
- Excel Writer< 1 %
- JSON Transformer< 1 %
- Keras Network Executor< 1 %
- Path to String (Variable)< 1 %
- Parquet Reader< 1 %
- Substructure Matcher< 1 %
- X-Aggregator< 1 %
Number To String< 1 %- Normalizer Apply (PMML)< 1 %
- Normalizer (PMML)< 1 %
- Set Operator< 1 %
- Java Snippet Row Filter< 1 %
- NGram Creator< 1 %
- R Source (Table)< 1 %
Extract Date&Time Fields< 1 %- Fingerprints< 1 %
- RDKit Fingerprint< 1 %
Extract Attribute< 1 %Extract Outer/InnerHTML< 1 %Read MDB< 1 %- Murcko Scaffold< 1 %
Gradient Boosted Trees Predictor< 1 %- Ruleset Editor< 1 %
- DB Writer< 1 %
- Table Editor (JavaScript)< 1 %
- RDKit Find Murcko Scaffolds< 1 %
- RDKit To InChI< 1 %
- Quit WebDriver< 1 %
- MolImporter< 1 %
- Scorer< 1 %
- Capture Workflow Start< 1 %
- RDKit Substructure Filter< 1 %
- Normalize Plates (POC)< 1 %
- MzTabReader< 1 %
Database Reader< 1 %Recursive Loop End< 1 %Numeric Scorer< 1 %- Create Bit Vector< 1 %
- HiLite Table (legacy)< 1 %
- Generic Web Service Client< 1 %
- Value Filter (legacy)< 1 %
Python Script (1⇒2)< 1 %- Fingerprint Similarity< 1 %
- Canonical SMILES< 1 %
Flow Variable IF Switch (Flow Variable Value)< 1 %- Fingerprints Expander< 1 %
- Active Branch Inverter< 1 %
- Extract Variables (Data)< 1 %
Table Row to Variable< 1 %- Read Images< 1 %
Database Looping< 1 %Simple File Reader< 1 %- Numeric Scorer< 1 %
- Target Shuffling< 1 %
- Time Series Generator< 1 %
- k-Medoids< 1 %
- 3D Scatter Plot (Plotly)< 1 %
- Model Loop Start< 1 %
- DL4J Feedforward Predictor (Classification) (legacy)< 1 %
- Geo-Coordinate Row Filter< 1 %
- String to Term< 1 %
- External Tool (Labs)< 1 %
- Double Input (legacy)< 1 %
- Column Selection Widget< 1 %
- Time to String (legacy)< 1 %
- RDKit Optimize Geometry< 1 %
Table Extractor< 1 %- Load FASTA Files< 1 %
- MolSearch< 1 %
- Naive Bayes Predictor< 1 %
- Independent groups t-test< 1 %
- DB Table Creator< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Component Separator< 1 %
- Fingerprint Similarity< 1 %
- Indigo Fingerprint< 1 %
Flow Variable End IF< 1 %- R Snippet (2:1)< 1 %
- MolConverter< 1 %
- ARIMA Predictor< 1 %
- Download (legacy)< 1 %
Variable Loop End< 1 %- PNN Predictor< 1 %
Tree Ensemble Predictor (Regression)< 1 %Simple Regression Tree Predictor< 1 %Tree Ensemble Predictor< 1 %- Create Byte Vector< 1 %
- Domain Calculator< 1 %
- HiLite Row Splitter< 1 %
Number To String (PMML)< 1 %- External Tool< 1 %
- Item Set Finder (Borgelt)< 1 %
SAS7BDAT Reader< 1 %- Document Vector< 1 %
Strings To Document< 1 %- Boolean Input (legacy)< 1 %
- Integer Input (legacy)< 1 %
- String Input (legacy)< 1 %
- Value Selection (legacy)< 1 %
Python Script (1⇒1)< 1 %Double Input (legacy)< 1 %- R to Table< 1 %
- Date&Time Shift< 1 %
- Time Difference (legacy)< 1 %
- String to Date/Time (legacy)< 1 %
- Molecular Properties< 1 %
- RDKit Aromatizer< 1 %
- URL Extractor< 1 %
- Combine Columns by Header< 1 %
- ConsensusTextReader< 1 %
- Naming< 1 %
- Try (Data Ports)< 1 %
Variable to Table Column< 1 %Table Column to Variable< 1 %- Fixed Width File Reader< 1 %
- Fuzzy Rule Predictor< 1 %
- MDS< 1 %
- Tree Ensemble Predictor (Regression)< 1 %
- Perl Scripting< 1 %
- CAIM Applier< 1 %
- Filter Apply< 1 %
- Random Number Assigner (Apache)< 1 %
- DL4J Feedforward Predictor (Regression) (legacy)< 1 %
- Association Rule Learner (Borgelt)< 1 %
- LIBSVMPredictor< 1 %
- RSS Feed Reader< 1 %
- Sentence Extractor< 1 %
Column Filter Configuration< 1 %- Table to JSON< 1 %
- Python Source (legacy)< 1 %
- RDKit From IUPAC< 1 %
- RDKit Molecule Catalog Filter< 1 %
- RDKit Substructure Counter< 1 %
- Google Address Geocoder< 1 %
- Reaction Splitter< 1 %
- logP< 1 %
- Audio Data Extractor< 1 %
- URL to File Path (Variable)< 1 %
- Variable Condition Loop End< 1 %
- Linear Correlation< 1 %
- Number to String (PMML)< 1 %
- Conditional Box Plot (legacy)< 1 %
- Bag Of Words Creator< 1 %
- Scorer (JavaScript)< 1 %
- Decision Tree View (JavaScript)< 1 %
- Reaxys Reactions< 1 %
- TIBCO Spotfire File Reader< 1 %
- List Folders< 1 %
- Fingerprint Similarity< 1 %
Database Connection Table Reader< 1 %Database Writer< 1 %- Feature Selection Filter< 1 %
- Cluster Assigner< 1 %
Random Forest Learner (Regression)< 1 %- Distance Matrix Pair Extractor< 1 %
- Binner (Dictionary)< 1 %
Cell Splitter< 1 %- Kaplan-Meier Estimator< 1 %
CASE Switch Variable (Start)< 1 %CASE Switch Data (Start)< 1 %Merge Variables< 1 %- Crosstab< 1 %
- SDF Stripper< 1 %
- H2O to Table< 1 %
- Term Co-Occurrence Counter< 1 %
- Category to Class< 1 %
- RegEx Filter< 1 %
- Tag Filter< 1 %
- Term to String< 1 %
- Weka Predictor (3.6) (legacy)< 1 %
Date Input (legacy)< 1 %- Date&Time Input (legacy)< 1 %
- Global Thresholder< 1 %
- Image Resizer< 1 %
- Don't Save Start< 1 %
- Multiobjective Score Computation< 1 %
Python Script (1⇒1)< 1 %Python Script (2⇒1)< 1 %- R Snippet< 1 %
- Date/Time Shift (legacy)< 1 %
- Extract Time Window (legacy)< 1 %
- Country Extractor< 1 %
- RDKit Generate Coords< 1 %
- Information Gain Calculator< 1 %
- N-Gram Extractor< 1 %
Column Distance< 1 %Hash Calculator< 1 %- HTTP Retriever< 1 %
- HTML Parser< 1 %
- Tautomer Generator< 1 %
- Forge Align< 1 %
- Fingerprint to Binary String< 1 %
- Is Empty< 1 %
Flow Variable IF Switch< 1 %Loop End (Upto 4 ports)< 1 %- Load Local Mol2 Files< 1 %
- Fragments to MMPs< 1 %
- List To Set< 1 %
- Empty Collection to Missing< 1 %
- Load text-based files< 1 %
- Split Columns by Header< 1 %
- Range Splitter< 1 %
- R Snippet< 1 %
- Text Extractor< 1 %
- Find MIME-Type< 1 %
- Unzip Files (legacy)< 1 %
- Create File Name (legacy)< 1 %
- CSV Array Reader< 1 %
Line Reader< 1 %Backward Feature Elimination Filter< 1 %Variable Condition Loop End< 1 %Recursive Loop End (2 ports)< 1 %- Hierarchical Cluster Assigner (local)< 1 %
- Logistic Regression Learner< 1 %
- Tree Ensemble Learner (Regression)< 1 %
Random Forest Predictor< 1 %- Simple Regression Tree Predictor< 1 %
- Auto-Binner (Apply)< 1 %
- Category to Number (Apply)< 1 %
- Number to Category (Apply)< 1 %
- Many to One< 1 %
- Edit Nominal Domain< 1 %
- Filter Apply Row Splitter< 1 %
- Numeric Binner (PMML)< 1 %
- Column Filter (PMML)< 1 %
- One to Many (PMML)< 1 %
String To Number (PMML)< 1 %- String to Number (PMML)< 1 %
- Rule Engine (Dictionary)< 1 %
Rank Correlation< 1 %- Rank Correlation< 1 %
- Extract Table Dimension< 1 %
- Enrichment Plotter (legacy)< 1 %
- Interactive Table (legacy)< 1 %
Parquet Reader< 1 %- Parameterized DB Query Reader< 1 %
- Empty Table Creator< 1 %
- One Row to Many< 1 %
- Random Matcher< 1 %
- Distance Matrix Calculate< 1 %
- Model to Cell< 1 %
- OpenBabel< 1 %
- SAS7BDAT Reader< 1 %
- Radar Plot Appender< 1 %
- TF< 1 %
- Case Converter< 1 %
- Modifiable Term Filter< 1 %
- Stop Word Filter< 1 %
- PubMed Document Parser< 1 %
- Integer Configuration< 1 %
- Credentials Input (legacy)< 1 %
- File Upload (legacy)< 1 %
- Multiple Selections (legacy)< 1 %
- Single Selection (legacy)< 1 %
- Line Plot (JavaScript)< 1 %
- Tile View (JavaScript)< 1 %
Container Input (Variable)< 1 %- Container Output (Table)< 1 %
- Container Input (JSON)< 1 %
JSON Reader< 1 %- Quantile Filter< 1 %
- Image to DataRow< 1 %
- Image Properties< 1 %
- Image Normalizer< 1 %
- Dimension Cleaner< 1 %
- DoG Spot Detection< 1 %
- ImageJ Macro< 1 %
List Box Input (legacy)< 1 %- Webpage Retriever< 1 %
- Disturber Node< 1 %
- Duration to Number< 1 %
- Modify Time< 1 %
- Column to XML< 1 %
XML Reader< 1 %- Symmetry< 1 %
- RDKit Diversity Picker< 1 %
- RDKit Interactive Table< 1 %
- RDKit Open 3D Alignment< 1 %
- RDKit Salt Stripper< 1 %
- MapQuest Geocoder< 1 %
- Coordinate to Latitude/Longitude< 1 %
- URL Domain Extractor< 1 %
Execute JavaScript< 1 %- Page Source< 1 %
- Aromatizer< 1 %
- Valence Checker< 1 %
- Total Count< 1 %
Loop End (3 ports)< 1 %- Chunk Loop Run-to-time Loop Start< 1 %
- Run Garbage Collector< 1 %
- Set To List< 1 %
- PDB Downloader< 1 %
- Outlier Removal< 1 %
- Bi Reactor< 1 %
- pKa< 1 %
- URI to String< 1 %
- PCA Inversion< 1 %
- PMML Gradient Boosted Trees Predictor (Regression)< 1 %
- Random Forest Learner (Regression)< 1 %
- Denormalizer (PMML)< 1 %
- Shape Manager< 1 %
- TimeDelay Loop Start< 1 %
- TensorFlow Network Executor< 1 %
- Markup Tag Filter< 1 %
- Tika Parser URL Input< 1 %
- Punctuation Erasure< 1 %
- Document Data Assigner< 1 %
- Value Selection Configuration< 1 %
- Interactive Range Slider Filter Widget< 1 %
- Value Selection Widget< 1 %
- Container Input (Variable)< 1 %
- JSON to XML< 1 %
SAP Reader (Theobald Software)< 1 %- Modify Time Zone< 1 %
- XML Reader< 1 %
- XSLT< 1 %
- Remove Empty Rows< 1 %
- 3D WHIM< 1 %
Location Extractor< 1 %
Views
- This node has no views
Workflows
!Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub- (3D) Fragment library design workflowKNIME Hub
- 0_install_AI_extensionsKNIME Hub
- 00 Data GenerationKNIME Hub
- 00_Guided_Labeling_for_Document_Classification_(legacy)KNIME Hub
- Show all 1279 workflows
Links
- KNIME E-Learning Course: Column Filterwww.knime.com/knime-introductory-course/chapter3/section1/column-filter
- Java API documentation about regex patternshttp://download.oracle.com/javase/6/docs/api/java/util/regex/Pattern.html
- Java API documentation about regex matchinghttp://download.oracle.com/javase/6/docs/api/java/util/regex/Matcher.html
- how check the data type in file reader and add the odd one to new columnby gab1one on 2018-12-12forum.knime.com/p/51321
- Simple Loopby gab1one on 2018-03-05forum.knime.com/p/39233
- 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.