Transforms all possible values in a selected column each
into a new column. The value is set as the new column's name,
the cell values in that column are either 1, if that row
contains this possible value, or 0 if not.
The node appends as many columns as possible values are
defined for the selected column(s).
If a row contains a missing value in a selected column all
corresponding new columns contain the value 0.
To avoid duplicate column names with identical possible values
in different selected columns, the generated column name
includes the original column name in this case (i. e.
the name looks like possibleValue_originalColumnName).
The dialog of the node allows you only to select columns with
nominal values. If no column name appears in the dialog but your
input table contains nominal columns, you could use the DomainCalculator
node and connect its output to this node.
Options
Popular Predecessors
- Normalizer (Apply)6 %
- Missing Value6 %
- Domain Calculator5 %
- CSV Reader5 %
String To Number4 %- Column Filter4 %
- Normalizer3 %
- Data Explorer3 %
- Rule Engine3 %
- Number to String2 %
- Category to Number2 %
Cell Splitter2 %- Missing Value (Apply)2 %
- Joiner1 %
Row Filter (deprecated)1 %- GroupBy1 %
- Scorer1 %
Excel Reader (XLS)1 %- Excel Reader1 %
Column Appender< 1 %Scorer< 1 %- String Manipulation< 1 %
- File Reader< 1 %
Number To String (PMML)< 1 %- One to Many< 1 %
- Column Appender< 1 %
Joiner< 1 %- String to Number< 1 %
- Math Formula (Multi Column)< 1 %
- Math Formula< 1 %
- Auto-Binner< 1 %
- Java Snippet (simple)< 1 %
- Numeric Outliers< 1 %
Column Rename< 1 %File Reader< 1 %- Cell Splitter< 1 %
- Partitioning< 1 %
XLS Reader< 1 %- String to Date&Time< 1 %
- Column Expressions< 1 %
- Numeric Binner< 1 %
- Binner (Dictionary)< 1 %
- Concatenate< 1 %
- Color Manager< 1 %
- PCA< 1 %
- Duplicate Row Filter< 1 %
- Constant Value Column Filter< 1 %
Concatenate (Optional in)< 1 %- Statistics< 1 %
- Association Rule Learner< 1 %
Linear Correlation< 1 %- Missing Value Column Filter< 1 %
- RowID< 1 %
- Rule-based Row Filter< 1 %
- Reference Column Filter< 1 %
Row Splitter (deprecated)< 1 %- Box Plot (legacy)< 1 %
- Table Writer< 1 %
- X-Partitioner< 1 %
- Column Comparator< 1 %
- Many to One< 1 %
- Extract Time Window (legacy)< 1 %
- Decision Tree Predictor< 1 %
- Nominal Value Row Splitter< 1 %
Excel Reader (XLS)< 1 %- Python Script (legacy)< 1 %
- Date&Time Part Extractor< 1 %
- Modify Time< 1 %
- Outlier Removal< 1 %
CSV Reader< 1 %Random Forest Predictor< 1 %- Create Bit Vector< 1 %
- Column Combiner< 1 %
- Column Resorter< 1 %
- Sorter< 1 %
- Unpivot< 1 %
- Rule-based Row Splitter< 1 %
Extract Date&Time Fields< 1 %- String to Date/Time (legacy)< 1 %
- Lag Column< 1 %
- Normalizer (PMML)< 1 %
- Reference Column Resorter< 1 %
- DB Reader< 1 %
- Column Filter Configuration< 1 %
- Table Row to Variable< 1 %
- Split Collection Column< 1 %
Variable to Table Row< 1 %- Bootstrap Sampling< 1 %
- Number to Category (Apply)< 1 %
- Filter Apply Row Splitter< 1 %
- Denormalizer< 1 %
- Pivot< 1 %
- Normalizer Apply (PMML)< 1 %
- String Splitter (Regex)< 1 %
- Row Sampling< 1 %
- Shuffle< 1 %
- String Replacer< 1 %
- Table Transposer< 1 %
- Value Counter< 1 %
- Date&Time Difference< 1 %
- Feature Selection Loop Start (1:1)< 1 %
- Logistic Regression Learner< 1 %
- Random Forest Predictor< 1 %
- Category to Number (Apply)< 1 %
- CAIM Binner< 1 %
- DB Query Reader< 1 %
- JSON to Table< 1 %
- File Reader (Complex Format)< 1 %
- Table Reader< 1 %
- Feature Selection Filter< 1 %
- ROC Curve (JavaScript)< 1 %
- Files/Folders Meta Info< 1 %
- Create Collection Column< 1 %
- ARFF Reader< 1 %
Table Reader< 1 %- Table Creator< 1 %
- Java Snippet< 1 %
Loop End< 1 %- Column List Loop Start< 1 %
- k-Means< 1 %
- Linear Regression Learner< 1 %
- SMOTE< 1 %
- Auto-Binner (Apply)< 1 %
Cell Replacer< 1 %- Column Aggregator< 1 %
- Constant Value Column< 1 %
- Correlation Filter< 1 %
- Cross Joiner< 1 %
- Double to Integer< 1 %
- Equal Size Sampling< 1 %
- Nominal Value Row Filter< 1 %
- Reference Row Filter< 1 %
- Column Splitter< 1 %
- Ungroup< 1 %
- HiLite Table (legacy)< 1 %
Strings To Document< 1 %- Column Filter (legacy)< 1 %
Python Script (1⇒1)< 1 %- Loop End (Column Append)< 1 %
- Cluster Assigner< 1 %
- Logistic Regression Predictor< 1 %
- PCA Apply< 1 %
- Case Converter< 1 %
- Column Auto Type Cast< 1 %
- Numeric Binner (PMML)< 1 %
- One to Many (PMML)< 1 %
- Number to String (PMML)< 1 %
- Data Generator< 1 %
- Crosstab< 1 %
- Category to Class< 1 %
- Table View (JavaScript)< 1 %
- Scatter Plot (JavaScript)< 1 %
- Date&Time to String< 1 %
- Create Date&Time Range< 1 %
- Linear Correlation< 1 %
- Table Manipulator< 1 %
- String to Number (PMML)< 1 %
- String Manipulation (Multi Column)< 1 %
- IF Switch< 1 %
- Duration to Number< 1 %
Regex Extractor< 1 %- Read Excel Sheet Names< 1 %
- K Nearest Neighbor< 1 %
- Column Renamer (Dictionary)< 1 %
- Parquet Reader< 1 %
- Column Renamer< 1 %
- Collection to String< 1 %
- Naive Bayes Predictor< 1 %
- SOTA Predictor< 1 %
- Regex Extractor< 1 %
- Moving Aggregator< 1 %
- R Snippet< 1 %
- Chunk Loop Start< 1 %
- Simple Regression Tree Predictor< 1 %
- Cell Splitter By Position< 1 %
- Column Merger< 1 %
- Edit Nominal Domain< 1 %
Bag of Words Creator< 1 %- Column Selection (legacy)< 1 %
- Strings to Binary Objects< 1 %
Counting Loop Start< 1 %- Extract Missing Value Cause< 1 %
- Numeric Outliers (Apply)< 1 %
Read Excel Sheet Names (XLS)< 1 %- Table Row to Variable Loop Start< 1 %
K Nearest Neighbor< 1 %- One-way ANOVA< 1 %
- Extract Table Spec< 1 %
Document Data Extractor< 1 %- Legacy Date&Time to Date&Time< 1 %
Table Row To Variable Loop Start< 1 %- Polynomial Regression Learner< 1 %
- Regression Predictor< 1 %
- Ruleset Editor< 1 %
- SAS7BDAT Reader< 1 %
- Term to String< 1 %
- Multiple Selection Widget< 1 %
- Set Operator< 1 %
- Single sample t-test< 1 %
- Single Selection Configuration< 1 %
- Fuzzy c-Means< 1 %
Tree Ensemble Predictor< 1 %- Column to Grid< 1 %
Double To Int< 1 %- Number Rounder< 1 %
- Molecule Type Cast< 1 %
- SDF Reader< 1 %
Excel Reader (XLS)< 1 %- Global Thresholder< 1 %
- Date&Time-based Row Filter< 1 %
- Date Field Extractor (legacy)< 1 %
- Time Field Extractor (legacy)< 1 %
- Mask Date/Time (legacy)< 1 %
- X-Aggregator< 1 %
- Subset Matcher< 1 %
- Column Filter (PMML)< 1 %
- ROC Curve (legacy)< 1 %
- One Row to Many< 1 %
- Strings to Document< 1 %
- JSON Path< 1 %
Python Script (2⇒1)< 1 %- String to Duration< 1 %
- Feature Selection Loop Start (2:2)< 1 %
- Hierarchical Clustering< 1 %
- Reference Row Splitter< 1 %
- JSON Reader< 1 %
- Date&Time Shift< 1 %
- Normalize Plates (Z-Score)< 1 %
- Try (Data Ports)< 1 %
Table Column to Variable< 1 %Database Connection Table Reader< 1 %Database Reader< 1 %Line Reader< 1 %- Group Loop Start< 1 %
- SVM Predictor< 1 %
- Add Empty Rows< 1 %
Number To String< 1 %- Edit Numeric Domain< 1 %
String Replace (Dictionary)< 1 %- Cache< 1 %
- Empty Table Creator< 1 %
- k-Medoids< 1 %
- Similarity Search< 1 %
DL Network Executor< 1 %PMML Ensemble Predictor< 1 %- String Matcher< 1 %
- Document Vector< 1 %
- Document Vector Applier< 1 %
- Tags to String< 1 %
- Value Filter (legacy)< 1 %
- String Input (legacy)< 1 %
- R Snippet< 1 %
- Time to String (legacy)< 1 %
- XPath< 1 %
- WAV Reader< 1 %
- Shapefile Polygon Reader< 1 %
- Example Data< 1 %
Python Snippet< 1 %- Fingerprints Expander< 1 %
Variable to Table Column< 1 %Table Row to Variable< 1 %- Fixed Width File Reader< 1 %
List Files< 1 %- DBSCAN< 1 %
- MDS< 1 %
PCA Apply< 1 %- Entropy Scorer< 1 %
- Numeric Scorer< 1 %
- Tree Ensemble Predictor (Regression)< 1 %
- Distance Matrix Pair Extractor< 1 %
- Expand Bit Vector< 1 %
- Create Byte Vector< 1 %
- Expand Byte Vector< 1 %
- Column Name Extractor< 1 %
- Column Rename (Regex)< 1 %
- Table Validator< 1 %
- CAIM Applier< 1 %
- Edit Nominal Domain (Dictionary)< 1 %
- Filter Apply< 1 %
- Low Variance Filter< 1 %
- Many to One (PMML)< 1 %
String To Number (PMML)< 1 %- Rank< 1 %
- Rule Engine (Dictionary)< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
Rank Correlation< 1 %- Empty Table Switch< 1 %
CASE Switch Data (End)< 1 %- Extract Table Dimension< 1 %
- Conditional Box Plot (legacy)< 1 %
DB Loader< 1 %- DB Merge< 1 %
- Counter Generation< 1 %
- Random Label Assigner< 1 %
- Association Rule Learner (Borgelt)< 1 %
- Frequency Filter< 1 %
- Case Converter< 1 %
- N Chars Filter< 1 %
- Bag Of Words Creator< 1 %
- String to Term< 1 %
- Unique Term Extractor< 1 %
- Column Selection Configuration< 1 %
- Multiple Selections (legacy)< 1 %
- Tag Cloud (JavaScript)< 1 %
- JSON to XML< 1 %
- Image Generator< 1 %
- Dimension Extender< 1 %
- Image Resizer< 1 %
Python Script (1⇒1)< 1 %- Modify Date< 1 %
- Time Difference (legacy)< 1 %
- Remove Empty Rows< 1 %
- Load text-based files< 1 %
- Binary Objects to Strings< 1 %
- Table Column to Variable< 1 %
- Loop End< 1 %
- Naive Bayes Learner< 1 %
- Gradient Boosted Trees Predictor< 1 %
- Random Forest Learner< 1 %
- Decision Tree to Ruleset< 1 %
Parquet Reader< 1 %- Conditional Label Assigner< 1 %
- Scatter Plot (Plotly)< 1 %
- H2O to Table< 1 %
- Excel Writer< 1 %
- Java IF (Table)< 1 %
- Radar Plot Appender< 1 %
- Lift Chart (JavaScript)< 1 %
- Single Selection Widget< 1 %
- Container Input (Table)< 1 %
- Python Source (legacy)< 1 %
- RDKit Fingerprint< 1 %
Views
- This node has no views
Workflows
0. Lubes_Sales_Pred-ModelNodePit Space- 0. Lubes_Sales_Pred-ModelNodePit Space
- 00_Keras_Transfer_LearningKNIME Hub
- 00_Keras_Transfer_LearningKNIME Hub
- 01_BERT_Sentiment_AnalysisKNIME Hub
- Show all 325 workflows
Links
- Randomn value generatorby gab1one on 2019-02-25forum.knime.com/p/55129
- Loop for rule engine with new columnsby armingrudd on 2019-03-09forum.knime.com/p/55869
- Random Forest for categorical Databy armingrudd on 2018-09-18forum.knime.com/p/47790
- Building matrix using file informationby ipazin on 2023-06-14forum.knime.com/p/212715
- How can I transform all my Columns in order that they have only binary values?by mlauber71 on 2019-02-06forum.knime.com/p/54224
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.