This node allows columns to be split from the first table using the second table as reference table.
Options
Popular Successors
- Joiner7 %
- Add Table to R4 %
- Column Filter3 %
- Column Rename (Regex)2 %
- Table Transposer2 %
- RowID2 %
- Column Appender2 %
- Excel Writer2 %
Table Writer2 %- Concatenate2 %
- Missing Value Column Filter1 %
- GroupBy1 %
Joiner1 %- Denormalizer1 %
- End IF1 %
Variable to Table Column1 %- Column List Loop Start1 %
Number To String1 %- Rule-based Row Filter1 %
- Rule Engine1 %
- Rule-based Row Splitter1 %
Database Writer1 %- Column Renamer (Dictionary)1 %
- Reference Column Resorter1 %
- Group Loop Start< 1 %
String To Number< 1 %- Column Name Extractor< 1 %
- Missing Value< 1 %
- Column Splitter< 1 %
Excel Writer (XLS)< 1 %Concatenate (Optional in)< 1 %Cell Replacer< 1 %- Column Aggregator< 1 %
- Reference Column Filter< 1 %
- Low Variance Filter< 1 %
- Row Sampling< 1 %
CASE Switch Data (End)< 1 %- Column Expressions< 1 %
Loop End< 1 %- Reference Column Splitter< 1 %
- Reference Row Splitter< 1 %
Column Rename< 1 %String Replace (Dictionary)< 1 %- Extract Table Spec< 1 %
- String to Date&Time< 1 %
CSV Writer< 1 %- CSV Writer< 1 %
- Cell Splitter< 1 %
- Number to String< 1 %
- Column Renamer< 1 %
- Column Resorter< 1 %
- Constant Value Column< 1 %
- Cross Joiner< 1 %
- Table Validator (Reference)< 1 %
Row Splitter (deprecated)< 1 %Row Filter (deprecated)< 1 %- Reference Row Filter< 1 %
- Partitioning< 1 %
- Pivot< 1 %
- String Manipulation< 1 %
- Table Difference Finder< 1 %
- Rank Correlation< 1 %
- Molecule Type Cast< 1 %
- SDF Writer< 1 %
- Math Formula< 1 %
- Math Formula (Multi Column)< 1 %
- Table View (JavaScript)< 1 %
- Columns to JSON< 1 %
- Split Collection Column< 1 %
- Column Merger< 1 %
- Column to Grid< 1 %
Double To Int< 1 %- Nominal Value Row Splitter< 1 %
- String Splitter (Regex)< 1 %
- Statistics< 1 %
- DB Insert< 1 %
- RDKit Interactive Table< 1 %
Variable to Table Column< 1 %- Table Row to Variable< 1 %
Counting Loop Start< 1 %Variable Condition Loop End< 1 %Random Forest Learner< 1 %Random Forest Predictor< 1 %- Random Forest Predictor< 1 %
- Numeric Binner< 1 %
Cell Splitter< 1 %Column Appender< 1 %- Filter Apply< 1 %
- Numeric Row Splitter< 1 %
- Sorter< 1 %
- Extract Table Dimension< 1 %
- Table Editor (JavaScript)< 1 %
- Java Snippet< 1 %
- k-Means< 1 %
- Polynomial Regression Learner< 1 %
- Column Auto Type Cast< 1 %
- Lag Column< 1 %
- Duplicate Row Filter< 1 %
- Constant Value Column Filter< 1 %
- Filter Apply Row Splitter< 1 %
- Nominal Value Row Filter< 1 %
- Normalizer< 1 %
- Missing Value (Apply)< 1 %
- Unpivot< 1 %
CASE Switch Data (Start)< 1 %- Color Manager< 1 %
- DL4J Feedforward Predictor (Regression) (legacy)< 1 %
XLS Writer< 1 %Excel Writer (XLS)< 1 %Column Filter Configuration< 1 %- XGBoost Predictor (Regression)< 1 %
- Domain - Similarity< 1 %
- Split Columns by Header< 1 %
- Create Collection Column< 1 %
- Breakpoint< 1 %
Table Row To Variable Loop Start< 1 %Database Update< 1 %- Table Writer< 1 %
- Loop End (Column Append)< 1 %
Recursive Loop End (2 ports)< 1 %- X-Aggregator< 1 %
- Decision Tree Predictor< 1 %
K Nearest Neighbor< 1 %- Logistic Regression Learner< 1 %
Scorer< 1 %- Numeric Scorer< 1 %
- SVM Predictor< 1 %
- PCA< 1 %
Tree Ensemble Predictor< 1 %- Case Converter< 1 %
- Cell Splitter By Position< 1 %
- Column Combiner< 1 %
- Column Comparator< 1 %
- Correlation Filter< 1 %
- Edit Nominal Domain (Dictionary)< 1 %
- Double to Integer< 1 %
- Table Manipulator< 1 %
- Normalizer (Apply)< 1 %
- Denormalizer (PMML)< 1 %
- Value Counter< 1 %
- Renderer to Image< 1 %
- Rule-based Row Splitter (Dictionary)< 1 %
- Cronbach Alpha< 1 %
- Independent groups t-test< 1 %
- Empty Table Switch< 1 %
- Interactive Histogram (legacy)< 1 %
- Line Plot (legacy)< 1 %
- Interactive Table (legacy)< 1 %
Hive Loader (legacy)< 1 %- DB Loader< 1 %
- DB Transaction Start< 1 %
- k-Medoids< 1 %
- Keras Network Executor< 1 %
- PMML Predictor< 1 %
Table to HTML< 1 %- Line Chart (JFreeChart)< 1 %
Excel Sheet Appender (XLS)< 1 %Strings To Document< 1 %- Line Plot (JavaScript)< 1 %
- Container Output (Table)< 1 %
- String to JSON< 1 %
- Image Viewer< 1 %
Python Script (1⇒1)< 1 %Python Script (2⇒1)< 1 %- R Snippet< 1 %
- R View (Table)< 1 %
- GET Request< 1 %
- Date&Time Difference< 1 %
- Date&Time Part Extractor< 1 %
- Date&Time-based Row Filter< 1 %
Views
- This node has no views
Workflows
!Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub- 0_install_AI_extensionsKNIME Hub
- 00 Data GenerationKNIME Hub
00_xplan sf dbconv-insert via xport-AccountKNIME Hub- 01_AutoML_Component_via_Interactive_ViewsKNIME Hub
- Show all 262 workflows
Links
- No links available
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.