Reference Column Filter

Input Ports

Table from which columns are to be included or excluded

Table with the columns used as references

Output Ports

Table with filtered columns

Popular Predecessors

• Column Filter10 %
• Table Creator4 %
• Row Filter (deprecated)4 %
• Table Transposer4 %
• Excel Reader3 %
• Show all 429 recommendations

Popular Successors

• Row Aggregator10 %
• Value Lookup10 %
• Numeric Binner4 %
• Column Rename4 %
• Concatenate3 %
• Joiner3 %
• Column Filter3 %
• Column Appender2 %
• Row Filter (deprecated)2 %
• Excel Writer2 %
• CSV Writer2 %
• Reference Column Filter1 %
• GroupBy1 %
• Date&Time Shift< 1 %
• Loop End< 1 %
• Reference Column Resorter< 1 %
• Column Rename (Regex)< 1 %
• Constant Value Column< 1 %
• Duplicate Row Filter< 1 %
• Reference Row Filter< 1 %
• Excel Sheet Appender (XLS)< 1 %
• Missing Value< 1 %
• Sorter< 1 %
• Column Resorter< 1 %
• Math Formula< 1 %
• Rule Engine< 1 %
• Constant Value Column Filter< 1 %
• Partitioning< 1 %
• Joiner< 1 %
• Numeric Binner (PMML)< 1 %
• Data to Report< 1 %
• Logistic Regression Learner< 1 %
• Column List Loop Start< 1 %
• Auto-Binner< 1 %
• Table Difference Finder< 1 %
• Scorer< 1 %
• String to Number< 1 %
• String Manipulation< 1 %
• Missing Value Column Filter< 1 %
• Component Output< 1 %
• Database Update< 1 %
• Java Snippet< 1 %
• Random Forest Predictor< 1 %
• Column Renamer (Dictionary)< 1 %
• Normalizer< 1 %
• Table Transposer< 1 %
• Object Inserter< 1 %
• Loop End< 1 %
• Row Splitter (deprecated)< 1 %
• DB Writer< 1 %
• PCA Apply< 1 %
• Column Splitter< 1 %
• Unpivot< 1 %
• Line Chart (JFreeChart)< 1 %
• Python Script (1⇒1)< 1 %
• Table Column to Variable< 1 %
• Table Row To Variable Loop Start< 1 %
• Naive Bayes Predictor< 1 %
• PCA< 1 %
• Missing Value< 1 %
• String Splitter (Regex)< 1 %
• Interactive Table (legacy)< 1 %
• Table Writer< 1 %
• Loop End (Column Append)< 1 %
• PCA Compute< 1 %
• Table Validator (Reference)< 1 %
• Normalizer (Apply)< 1 %
• Ungroup< 1 %
• Chemical File Writer< 1 %
• Try (Data Ports)< 1 %
• RProp MLP Learner< 1 %
• Tree Ensemble Learner< 1 %
• Tree Ensemble Learner< 1 %
• Column Auto Type Cast< 1 %
• Column Aggregator< 1 %
• Column Name Extractor< 1 %
• Lag Column< 1 %
• One to Many< 1 %
• Double to Integer< 1 %
• Equal Size Sampling< 1 %
• Low Variance Filter< 1 %
• RowID< 1 %
• IF Switch< 1 %
• CASE Switch Data (Start)< 1 %
• Extract Table Dimension< 1 %
• Extract Table Spec< 1 %
• Random Boolean Assigner< 1 %
• TF< 1 %
• Column Filter Configuration< 1 %
• R Learner< 1 %
• Table to HTML String< 1 %
• Variable to Table Column< 1 %
• Table Writer< 1 %
• Recursive Loop End< 1 %
• Naive Bayes Predictor< 1 %
• Logistic Regression Learner< 1 %
• Column Renamer< 1 %
• Filter Apply< 1 %
• String Replace (Dictionary)< 1 %
• Rule-based Row Splitter< 1 %
• Excel Sheet Appender (XLS)< 1 %
• Column Filter (legacy)< 1 %
• Column Selection (legacy)< 1 %
• Python Script< 1 %
• String to Date&Time< 1 %
• Join< 1 %
• Table Column to Variable< 1 %
• Table Creator< 1 %
• X-Partitioner< 1 %
• Tree Ensemble Predictor< 1 %
• Cell Splitter< 1 %
• Number to String< 1 %
• Reference Row Splitter< 1 %
• Missing Value (Apply)< 1 %
• String Replacer< 1 %
• Rule-based Row Filter< 1 %
• CASE Switch Start< 1 %
• End IF< 1 %
• Interactive Pie chart (legacy)< 1 %
• Scatter Plot (legacy)< 1 %
• Table View< 1 %
• Workflow Executor< 1 %
• DB Loader< 1 %
• Numeric Distances< 1 %
• Column Expressions< 1 %
• Math Formula (Multi Column)< 1 %
• Table View (JavaScript)< 1 %
• Python Predictor (legacy)< 1 %
• Molomics JPMML Regression Predictor< 1 %
• Variable to Table Column< 1 %
• Variable to Table Row< 1 %
• Database Table Creator< 1 %
• Counting Loop Start< 1 %
• Group Loop Start< 1 %
• Recursive Loop End (2 ports)< 1 %
• Recursive Loop End< 1 %
• Naive Bayes Learner< 1 %
• K Nearest Neighbor< 1 %
• MultiLayerPerceptron Predictor< 1 %
• Random Forest Learner< 1 %
• Column Appender< 1 %
• Cross Joiner< 1 %
• Pivot< 1 %
• Column Filter (PMML)< 1 %
• Cronbach Alpha< 1 %
• Data Explorer< 1 %
• Statistics< 1 %
• Empty Table Switch< 1 %
• Color Manager< 1 %
• DB Insert< 1 %
• DB Update< 1 %
• Conditional Box Plot< 1 %
• PMML Predictor< 1 %
• Table to R< 1 %
• XGBoost Predictor< 1 %
• RDKit Interactive Table< 1 %
• Domain - Similarity< 1 %
• Domain - Leverage< 1 %
• Type Conversion< 1 %
• Group< 1 %
• Lookup and Add Columns< 1 %
• MolConverter< 1 %
• Create Collection Column< 1 %
• Table Row to Variable< 1 %
• CSV Writer< 1 %
• Database Writer< 1 %
• Extract Context Properties< 1 %
• Feature Selection Loop Start (1:1)< 1 %
• Chunk Loop Start< 1 %
• Variable Condition Loop End< 1 %
• Table Row to Variable Loop Start< 1 %
• Fuzzy c-Means< 1 %
• Decision Tree Predictor< 1 %
• K Nearest Neighbor< 1 %
• Linear Regression Learner< 1 %
• Logistic Regression Predictor< 1 %
• Regression Predictor< 1 %
• SOTA Predictor< 1 %
• PCA Apply< 1 %
• Gradient Boosted Trees Learner (Regression)< 1 %
• Gradient Boosted Trees Predictor (Regression)< 1 %
• Random Forest Learner< 1 %
• Random Forest Learner (Regression)< 1 %
• Random Forest Predictor< 1 %
• Random Forest Predictor (Regression)< 1 %
• Simple Regression Tree Learner< 1 %
• Simple Regression Tree Predictor< 1 %
• Create Bit Vector< 1 %
• Cell Replacer< 1 %
• Cell Splitter< 1 %
• Column Combiner< 1 %
• Column Comparator< 1 %
• Category to Number (Apply)< 1 %
• Category to Number< 1 %
• Column Merger< 1 %
• Linear Correlation< 1 %
• Correlation Filter< 1 %
• Domain Calculator< 1 %
• Reference Column Splitter< 1 %
• Nominal Value Row Filter< 1 %
• Table Manipulator< 1 %
• Row Sampling< 1 %
• String Manipulation (Multi Column)< 1 %
• Value Counter< 1 %
• CASE Switch End< 1 %
• Line Plot (legacy)< 1 %
• Capture Workflow End< 1 %
• PostgreSQL Connector< 1 %
• DB Connector< 1 %
• Pie/Donut Chart< 1 %
• JPython Function (Legacy)< 1 %
• Excel Writer (XLS)< 1 %
• Document Vector< 1 %
• Weka Predictor (3.7)< 1 %
• File Download (legacy)< 1 %
• Heatmap (JavaScript)< 1 %
• Line Plot (JavaScript)< 1 %
• Shapley Values Loop Start< 1 %
• Python Script (1⇒2)< 1 %
• Python Script (legacy)< 1 %
• R Snippet< 1 %
• Date&Time Part Extractor< 1 %
• Date&Time-based Row Filter< 1 %
• XGBoost Predictor (Regression)< 1 %
• Dumb Joiner< 1 %
• Glide Ligand Docking< 1 %
• Number Formatter< 1 %
• Variable to Table Column< 1 %
• Table Column to Variable< 1 %
• Database Reader< 1 %
• PCA< 1 %
• String To Number< 1 %
• String Manipulation (Variable)< 1 %
• Independent groups t-test< 1 %
• PMML Predictor< 1 %
• Java Snippet (simple)< 1 %
• Category to Class< 1 %
• String Matcher< 1 %
• Nominal Row Filter Configuration< 1 %
• Fingerprints< 1 %
• Catch Errors (Data Ports)< 1 %
• ARFF Writer< 1 %
• Naive Bayes Learner< 1 %
• Fuzzy Rule Predictor< 1 %
• Hierarchical Clustering< 1 %
• Regression Predictor< 1 %
• Scorer< 1 %
• Tree Ensemble Learner< 1 %
• Normalizer (PMML)< 1 %
• Number Rounder< 1 %
• Numeric Outliers< 1 %
• Crosstab< 1 %
• Box Plot (legacy)< 1 %
• Parquet Writer< 1 %
• Table to Spark< 1 %
• Parallel Chunk Start< 1 %
• Histogram< 1 %
• LIBSVMLearner< 1 %
• Send to Power BI< 1 %
• Term to String< 1 %
• JPMML Classifier< 1 %
• Column Selection Widget< 1 %
• R View (Table)< 1 %
• Data to Report (BIRT)< 1 %
• Date&Time to String< 1 %
• XGBoost Linear Ensemble Learner< 1 %
• Remove Empty Rows< 1 %
• Integer Column Filter< 1 %
• Filter Rows< 1 %
• Neutralizer< 1 %
• Parameter Mutual Information< 1 %
• R Snippet< 1 %
• Inject Variables (Data)< 1 %
• Table Row to Variable< 1 %
• Loop End (2 ports)< 1 %
• Variable Condition Loop End< 1 %
• PNN Learner (DDA)< 1 %
• DBSCAN< 1 %
• Polynomial Regression Learner< 1 %
• SVM Predictor< 1 %
• Tree Ensemble Learner (Regression)< 1 %
• Gradient Boosted Trees Predictor< 1 %
• Gradient Boosted Trees Predictor< 1 %
• Tree Ensemble Predictor< 1 %
• Add Empty Rows< 1 %
• Concatenate (Optional in)< 1 %
• Binner (Dictionary)< 1 %
• Double To Int< 1 %
• Denormalizer< 1 %
• Rank< 1 %
• Set Operator< 1 %
• Shuffle< 1 %
• Rule-based Row Splitter (Dictionary)< 1 %
• One-way ANOVA< 1 %
• CASE Switch Data (End)< 1 %
• Cache< 1 %
• Pie chart (legacy)< 1 %
• Scatter Matrix (legacy)< 1 %
• Destroy Spark Context< 1 %
• SDF Writer< 1 %
• DB Table Selector< 1 %
• Similarity Search< 1 %
• Pie/Donut Chart (JavaScript)< 1 %
• Histogram Chart (JFreeChart)< 1 %
• XLS Sheet Appender< 1 %
• XLS Writer< 1 %
• Excel Writer (XLS)< 1 %
• Radar Plot Appender< 1 %
• N Chars Filter< 1 %
• Document Data Extractor< 1 %
• Strings to Document< 1 %
• t-SNE (L. Jonsson)< 1 %
• JPMML Regression Predictor< 1 %
• Value Selection (legacy)< 1 %
• ROC Curve (JavaScript)< 1 %
• Table Editor (JavaScript)< 1 %
• Python Script (2⇒1)< 1 %
• GET Request< 1 %
• Date&Time Difference< 1 %
• Modify Time< 1 %
• XGBoost Tree Ensemble Learner< 1 %
• XGBoost Tree Ensemble Learner (Regression)< 1 %
• Row Splitter (col+)< 1 %
• RDKit Descriptor Calculation< 1 %
• RDKit From Molecule< 1 %
• Double Column Filter< 1 %
• String To Missing< 1 %
• Write MDB< 1 %
• Component Separator< 1 %
• Derive Fields< 1 %
• PiMaps Projection< 1 %
• Phase DB Creation< 1 %
• TIBCO Spotfire File Writer< 1 %
• Multiport Loop End< 1 %
• Benchmark Start< 1 %
• Combine Columns by Header< 1 %
• Outlier Removal< 1 %
• Write To Excel Template (deprecated)< 1 %
• Advanced Discretization (Apply)< 1 %
• Fingerprint Similarity< 1 %
• 2D/3D Scatterplot< 1 %
• String to Molecule< 1 %
• XLS Coloured Writer< 1 %
• Split Collection Column< 1 %
• URL to File Path< 1 %
• Wait...< 1 %
• Create File Name (legacy)< 1 %
• Table Row to Variable< 1 %
• Parameterized Database Query< 1 %
• Table Reader< 1 %
• Variable Creator< 1 %
• Java Edit Variable< 1 %
• Feature Selection Filter< 1 %
• Interval Loop Start< 1 %
• Recursive Loop Start< 1 %
• Recursive Loop Start< 1 %
• X-Aggregator< 1 %
• PNN Predictor< 1 %
• Cluster Assigner< 1 %
• Silhouette Coefficient< 1 %
• k-Means< 1 %
• Decision Tree Learner< 1 %
• Decision Tree Learner< 1 %
• Numeric Scorer< 1 %
• SMOTE< 1 %
• SVM Learner< 1 %
• PCA Compute< 1 %
• Tree Ensemble Predictor (Regression)< 1 %
• Random Forest Learner< 1 %
• Random Forest Learner (Regression)< 1 %
• Random Forest Predictor< 1 %
• Random Forest Predictor (Regression)< 1 %
• Simple Regression Tree Predictor< 1 %
• Gradient Boosted Trees Learner< 1 %
• Gradient Boosted Trees Learner< 1 %
• Gradient Boosted Trees Predictor< 1 %
• Tree Ensemble Learner (Regression)< 1 %
• Tree Ensemble Predictor (Regression)< 1 %
• Auto-Binner (Apply)< 1 %
• Case Converter< 1 %
• Cell Splitter By Position< 1 %
• Number To String< 1 %
• Column to Grid< 1 %
• Many to One< 1 %
• Linear Correlation< 1 %
• Table Validator< 1 %
• Extract Missing Value Cause< 1 %
• Filter Apply Row Splitter< 1 %
• HiLite Row Splitter< 1 %
• Nominal Value Row Splitter< 1 %
• Row Filter (Labs)< 1 %
• Row Splitter (Labs)< 1 %
• Many to One (PMML)< 1 %
• One to Many (PMML)< 1 %
• Normalizer Apply (PMML)< 1 %
• Denormalizer (PMML)< 1 %
• String to Number (PMML)< 1 %
• Numeric Row Splitter< 1 %
• Target Shuffling< 1 %
• Rule-based Row Filter (Dictionary)< 1 %
• Rank Correlation< 1 %
• Rank Correlation< 1 %
• Linear Discriminant Analysis< 1 %
• Shapiro-Wilk Test< 1 %
• Kruskal-Wallis Test< 1 %
• Create Temp Dir (legacy)< 1 %
• Merge Variables< 1 %
• Conditional Box Plot (legacy)< 1 %
• Histogram (legacy)< 1 %
• Interactive Histogram (legacy)< 1 %
• Molecule Type Cast< 1 %
• SDF Stripper< 1 %
• Parallel Chunk End< 1 %
• Parameterized DB Query Reader< 1 %
• DB Transaction Start< 1 %
• DB Table Creator< 1 %
• Random Number Assigner< 1 %
• Mahalanobis Distance< 1 %
• Distance Matrix Calculate< 1 %
• Keras Network Executor< 1 %
• Keras Network Learner< 1 %
• DL Python Network Executor< 1 %
• 3D Scatter Plot (Plotly)< 1 %
• Bar Chart< 1 %
• Bar Chart (JavaScript)< 1 %
• Box Plot< 1 %
• Line Plot (Plotly)< 1 %
• JavaScript Parallel Coordinates Plot< 1 %
• Stacked Area Chart< 1 %
• Stacked Area Chart (JavaScript)< 1 %
• Delegating Loop End (deprecated)< 1 %
• PMML Ensemble Predictor< 1 %
• PMML Ensemble Predictor< 1 %
• Prediction Fusion< 1 %
• Variable Expressions< 1 %
• Table to HTML< 1 %
• Table to PDF< 1 %
• MoSS MCSS Molecule Similarity< 1 %
• Table to H2O< 1 %
• Association Rule Learner (Borgelt)< 1 %
• HeatMap (JFreeChart)< 1 %
• Interval Chart (JFreeChart)< 1 %
• LIBSVMPredictor< 1 %
• Excel Reader< 1 %
• Java IF (Table)< 1 %
• Java Snippet Row Splitter< 1 %
• Tableau Writer (Hyper)< 1 %
• Tableau Writer< 1 %
• Dictionary Replacer (File-based)< 1 %
• Number Filter< 1 %
• Stop Word Filter< 1 %
• OpenNLP NE tagger< 1 %
• Apriori (3.7)< 1 %
• LWL (3.7)< 1 %
• Google Sheets Updater< 1 %
• Column Selection Configuration< 1 %
• Column Selection Configuration< 1 %
• Value Filter (legacy)< 1 %
• Generic JavaScript View (JavaScript)< 1 %
• Scatter Plot (JavaScript)< 1 %
• Tag Cloud (JavaScript)< 1 %
• Column Filter Widget< 1 %
• Date&Time Widget< 1 %
• Container Output (Table)< 1 %
• Table to JSON< 1 %
• Columns to JSON< 1 %
• Image Normalizer< 1 %
• Image Viewer< 1 %
• Image Writer< 1 %
• Python Predictor< 1 %
• Python Script (1⇒1)< 1 %
• Python Script (2⇒1)< 1 %
• Python Object Reader (legacy)< 1 %
• Python Script (2⇒2)< 1 %
• Python View (legacy)< 1 %
• Add Table to R< 1 %
• R Predictor< 1 %
• Table Difference Checker< 1 %
• Create Date&Time Range< 1 %
• Extract Date&Time Fields< 1 %
• Modify Date< 1 %
• Window Loop Start< 1 %
• Time Difference (legacy)< 1 %
• Date Field Extractor (legacy)< 1 %
• Time Field Extractor (legacy)< 1 %
• Moving Aggregator< 1 %
• Moving Average< 1 %
• String to Date/Time (legacy)< 1 %
• Predict< 1 %
• Molecule to CDK< 1 %
• Sum Formula< 1 %
• Presto Chooser< 1 %
• RDKit From IUPAC< 1 %
• RDKit Molecule Extractor< 1 %
• RDKit Fingerprint< 1 %
• HTTP Retriever< 1 %