This node is part of the legacy Quick Form nodes and will be deprecated soon. The replacement for this node can be found in the configuration/widget nodes. For more information on these new nodes see this blog post.
Takes a data table and returns a filtered data table with only the selected columns. The selection can also be controlled from a quickfrom (WebPortal).
The node supports custom CSS styling. You can simply put CSS rules into a single string and set it as a flow variable 'customCSS' in the node configuration dialog. You will find the list of available classes and their description on our documentation page.
Options
Popular Predecessors
Number To String3 %Cell Splitter2 %Column Appender2 %- File Reader2 %
- Math Formula1 %
- String to Date&Time1 %
XLS Reader1 %- CSV Reader1 %
- Value Counter1 %
- Auto-Binner1 %
String To Number1 %Excel Reader (XLS)1 %Concatenate (Optional in)< 1 %Joiner< 1 %Strings To Document< 1 %- String to Date/Time (legacy)< 1 %
- Number to String< 1 %
CSV Reader< 1 %- Correlation Filter< 1 %
- Column Filter< 1 %
Row Filter (deprecated)< 1 %- Column Rename (Regex)< 1 %
Linear Correlation< 1 %- JSON Path< 1 %
- JSON to Table< 1 %
- Scatter Plot (JavaScript)< 1 %
- One to Many< 1 %
- Missing Value Column Filter< 1 %
- Row Sampling< 1 %
- Strings to Document< 1 %
Table Column to Variable< 1 %File Reader< 1 %- Missing Value< 1 %
- String Replacer< 1 %
- List Box Input (legacy)< 1 %
- Column Expressions (legacy)< 1 %
- File Reader (Complex Format)< 1 %
Table Row To Variable Loop Start< 1 %- Table Creator< 1 %
- Java Snippet< 1 %
- Column Merger< 1 %
- Reference Column Filter< 1 %
- Statistics< 1 %
Excel Reader (XLS)< 1 %- Fingerprint Similarity< 1 %
- Cell Splitter< 1 %
- String to Number< 1 %
- Integer Input (legacy)< 1 %
- Table Column to Variable< 1 %
- Joiner< 1 %
- Data Explorer< 1 %
Table Row to Variable< 1 %Scorer< 1 %- Domain Calculator< 1 %
- Partitioning< 1 %
- Table Transposer< 1 %
- Value Filter (legacy)< 1 %
- Value Selection (legacy)< 1 %
- HTML Parser< 1 %
- Decision Tree Predictor< 1 %
- Table Row to Variable< 1 %
- Naive Bayes Predictor< 1 %
Table Reader< 1 %- k-Means< 1 %
- Simple Regression Tree Predictor< 1 %
- Column Combiner< 1 %
- Column Resorter< 1 %
- HiLite Row Splitter< 1 %
- Sorter< 1 %
- Ungroup< 1 %
- Molecule Type Cast< 1 %
- File Chooser (legacy)< 1 %
- Multiple Selections (legacy)< 1 %
- XPath< 1 %
PCA Apply< 1 %- Duplicate Row Filter< 1 %
Number To String (PMML)< 1 %- Unpivot< 1 %
Excel Reader (XLS)< 1 %- Java Snippet Row Filter< 1 %
- Column Filter Configuration< 1 %
- Tag Cloud (JavaScript)< 1 %
- Column Appender< 1 %
- Excel Reader< 1 %
- Snowball Stemmer< 1 %
- Column List Loop Start< 1 %
Recursive Loop Start< 1 %- Regression Predictor< 1 %
- SMOTE< 1 %
- Concatenate< 1 %
- Column Comparator< 1 %
- Category to Number< 1 %
- Column Aggregator< 1 %
- Column Name Extractor< 1 %
- Nominal Value Row Filter< 1 %
Row Splitter (deprecated)< 1 %- Reference Row Filter< 1 %
- GroupBy< 1 %
- Denormalizer< 1 %
- Column Filter (PMML)< 1 %
Column Rename< 1 %- Number Rounder< 1 %
- RowID< 1 %
- String Manipulation< 1 %
- Rule-based Row Filter< 1 %
- Rule Engine< 1 %
- Rule-based Row Splitter< 1 %
- Color Manager< 1 %
- SDF Reader< 1 %
- Fingerprint Bayesian Predictor< 1 %
- Math Formula (Multi Column)< 1 %
- Java Snippet (simple)< 1 %
- Column Filter (legacy)< 1 %
- Column Selection (legacy)< 1 %
- Table View (JavaScript)< 1 %
- Date&Time to String< 1 %
- Column Renamer (Dictionary)< 1 %
- Extract Missing Value Cause< 1 %
- Numeric Row Splitter< 1 %
- End IF< 1 %
- Save Workflow< 1 %
- DB Reader< 1 %
- TimeDelay Loop Start< 1 %
- PMML Predictor< 1 %
- POST Request< 1 %
- Date&Time-based Row Filter< 1 %
- Table Reader< 1 %
- Loop End< 1 %
- Table Row to Variable Loop Start< 1 %
- Constant Value Column Filter< 1 %
- Row Filter (Labs)< 1 %
- SharePoint Online List Reader< 1 %
Regex Extractor< 1 %Color Appender< 1 %- Reference Database Table Exists IF Switch (Legacy)< 1 %
- Outlier Removal< 1 %
- Upload (legacy)< 1 %
Loop End< 1 %- RDKit Substructure Filter< 1 %
- R-Group Decomposer< 1 %
- Split Collection Column< 1 %
- Polynomial Regression Learner< 1 %
- IF Switch< 1 %
- Extract Table Dimension< 1 %
- R Snippet< 1 %
- Logistic Regression Predictor< 1 %
- Value Selection Configuration< 1 %
- Web Page Content Extractor< 1 %
Variable to Table Column< 1 %- Hierarchical Clustering< 1 %
- Numeric Binner< 1 %
- Cross Joiner< 1 %
- String Splitter (Regex)< 1 %
- Box Plot (legacy)< 1 %
- Counter Generation< 1 %
- Distance Matrix Calculate< 1 %
- Weka Predictor (3.7)< 1 %
- R to Table< 1 %
Extract Date&Time Fields< 1 %- Text Classifier Predictor< 1 %
- File Meta Info (legacy)< 1 %
- Add Empty Rows< 1 %
- Double to Integer< 1 %
- Shuffle< 1 %
CASE Switch Data (Start)< 1 %- Tika Parser< 1 %
- Value Filter Definition (legacy)< 1 %
- MolImporter< 1 %
List Files< 1 %Generic Loop Start< 1 %Naive Bayes Predictor< 1 %- MultiLayerPerceptron Predictor< 1 %
Gradient Boosted Trees Predictor< 1 %- Pivot< 1 %
- Rank< 1 %
Linear Discriminant Analysis< 1 %CASE Switch Variable (Start)< 1 %CASE Switch Data (End)< 1 %- Timer Info< 1 %
- Crosstab< 1 %
- Spark to Table< 1 %
- Similarity Search< 1 %
- String Input (legacy)< 1 %
- Python Edit Variable (legacy)< 1 %
- Time to String (legacy)< 1 %
Web Log Reader< 1 %- HTTP Result Data Extractor< 1 %
- Database List Tables (Legacy)< 1 %
- Shapefile Polygon Reader< 1 %
- Inject Variables (Data)< 1 %
- ARFF Reader< 1 %
CSV Writer< 1 %Database Connection Table Reader< 1 %Database SQL Executor< 1 %Line Reader< 1 %- Chunk Loop Start< 1 %
Regression Predictor< 1 %- Random Forest Learner (Regression)< 1 %
Random Forest Predictor< 1 %- Category to Number (Apply)< 1 %
- Lag Column< 1 %
- Column to Grid< 1 %
- Numeric Outliers< 1 %
- Cache< 1 %
Merge Variables< 1 %- DB Update< 1 %
- Distance Matrix Reader< 1 %
- k-Medoids< 1 %
- Stop Word Filter< 1 %
- RSS Feed Reader< 1 %
- Sentence Extractor< 1 %
Python Script (2⇒1)< 1 %- Date Field Extractor (legacy)< 1 %
- RDKit Descriptor Calculation< 1 %
- RDKit Two Component Reaction< 1 %
- Feed Parser< 1 %
Extract Attribute< 1 %- Variable Loop End< 1 %
- Association Rule Learner< 1 %
- Normalizer (PMML)< 1 %
- DB Query Reader< 1 %
- Reaction Builder< 1 %
- MolConverter< 1 %
- Fingerprints Expander< 1 %
- URL to File Path< 1 %
- Extract Variables (Data)< 1 %
Variable to Table Row< 1 %Database Reader< 1 %- Loop End (Column Append)< 1 %
Loop End (Column Append)< 1 %K Nearest Neighbor< 1 %PCA Compute< 1 %Tree Ensemble Predictor< 1 %- Random Forest Predictor (Regression)< 1 %
- Binner (Dictionary)< 1 %
Cell Replacer< 1 %- Column Auto Type Cast< 1 %
- Constant Value Column< 1 %
- Reference Row Splitter< 1 %
- Subset Matcher< 1 %
- Normalizer< 1 %
- Missing Value (Apply)< 1 %
- Column Splitter< 1 %
- Data Generator< 1 %
- Term Co-Occurrence Counter< 1 %
- Category to Class< 1 %
- NGram Creator< 1 %
- Case Converter< 1 %
- N Chars Filter< 1 %
- Number Filter< 1 %
- Document Data Extractor< 1 %
Document vector< 1 %- Term to String< 1 %
- String to JSON< 1 %
- Labeling Properties< 1 %
- Modify Time< 1 %
- Lipinski's Rule-of-Five< 1 %
- RDKit Molecule Substructure Filter< 1 %
- RDKit Fingerprint< 1 %
- CIR< 1 %
- Canonical SMILES< 1 %
- Reaction Splitter< 1 %
- Type< 1 %
- Load FASTA Files< 1 %
- Create Collection Column< 1 %
- Download (legacy)< 1 %
- List Remote Files (legacy)< 1 %
- Strings to Binary Objects< 1 %
- URI to String< 1 %
- Try (Data Ports)< 1 %
Database Delete< 1 %Database Update< 1 %Loop End (2 ports)< 1 %Counting Loop Start< 1 %Interval Loop Start< 1 %PCA< 1 %- Linear Regression Learner< 1 %
- SVM Predictor< 1 %
- PCA< 1 %
Random Forest Predictor< 1 %Simple Regression Tree Predictor< 1 %- Tree Ensemble Learner (Regression)< 1 %
- Random Forest Predictor< 1 %
- Create Bit Vector< 1 %
- Cell Splitter By Position< 1 %
- Linear Correlation< 1 %
- Equal Size Sampling< 1 %
- Filter Apply< 1 %
- One to Many (PMML)< 1 %
String To Number (PMML)< 1 %- String Manipulation (Variable)< 1 %
- Target Shuffling< 1 %
- Paired t-test< 1 %
- Extract Table Spec< 1 %
- Shape Manager< 1 %
- Size Manager< 1 %
- SDF Extractor< 1 %
- Parallel Chunk End (multi port)< 1 %
- Parallel Chunk Start< 1 %
- H2 Connector< 1 %
- Random Matcher< 1 %
PMML Predictor< 1 %- OpenBabel< 1 %
- Generic Web Service Client< 1 %
- Topic Extractor (Parallel LDA)< 1 %
- Keygraph Keyword Extractor< 1 %
- Dictionary Filter< 1 %
- Punctuation Erasure< 1 %
- RegEx Filter< 1 %
- Replacer< 1 %
- Bag Of Words Creator< 1 %
Document Data Extractor< 1 %- String to Term< 1 %
Google Analytics Query (deprecated)< 1 %- Text Output (legacy)< 1 %
- Double Input (legacy)< 1 %
- Generic JavaScript View (JavaScript)< 1 %
- ROC Curve (JavaScript)< 1 %
- Column Filter Widget< 1 %
- Column Selection Widget< 1 %
- Container Input (Table)< 1 %
JSON Reader< 1 %- Network Analyzer< 1 %
- Python Source (legacy)< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Moving Aggregator< 1 %
- XGBoost Predictor< 1 %
- Column to XML< 1 %
- RDKit Kekulizer< 1 %
- RDKit From Molecule< 1 %
- RDKit Molecule Catalog Filter< 1 %
- RDKit R-Group Decomposition (deprecated)< 1 %
- Latitude/Longitude to Coordinate< 1 %
Find Elements< 1 %- Molecule Properties< 1 %
- Speedy SMILES De-salt< 1 %
- Create Well Position< 1 %
- Variable to Table Column< 1 %
- Group Loop Start< 1 %
- K Nearest Neighbor< 1 %
- Scorer< 1 %
- Numeric Scorer< 1 %
- Gradient Boosted Trees Predictor< 1 %
- Case Converter< 1 %
- Row Splitter (Labs)< 1 %
- Table Manipulator< 1 %
- Number to String (PMML)< 1 %
- String Manipulation (Multi Column)< 1 %
- Ruleset Editor< 1 %
- One Row to Many< 1 %
- Decompress Files< 1 %
- Shapefile reader< 1 %
- Integer Configuration< 1 %
- String Configuration< 1 %
- Multiple Selection Configuration< 1 %
- Boolean Input (legacy)< 1 %
- Table Editor (JavaScript)< 1 %
- Binary Classification Inspector< 1 %
- GET Request< 1 %
- Webpage Retriever< 1 %
- Date&Time Difference< 1 %
- Molecular Properties< 1 %
- Hash Calculator< 1 %
Views
- Interactive View: Column filter
- Select multiple columns.
Workflows
_01_ChemicalLibraryEnumerationKNIME Hub- 01_2010urban_InequalityKNIME Hub
- 01_CustomerSegmentation_ModelLearning_webKNIME Hub
- 01_CustomerSegmentation_ModelLearning_webKNIME Hub
- 01_Guided_Analytics_for_ML_AutomationKNIME Hub
- Show all 75 workflows
Links
- un-join tableby izaychik63 on 2019-10-01forum.knime.com/p/71452
- how check the data type in file reader and add the odd one to new columnby izaychik63 on 2018-12-13forum.knime.com/p/51426
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.