Updates column names of a table according to the mapping in second dictionary table. The dictionary table needs to contain two columns, one of which contains the lookup (i.e. the column names of the table to be renamed), the other column containing the new column names. The lookup column may be the RowID column.
If the assigned new value in the value column is missing, the original column name will be retained. If the lookup column contains duplicates of the original column names, the node will fail.
Options
Popular Predecessors
- Column Name Extractor9 %
- Table Transposer9 %
- Table Creator6 %
- String Manipulation5 %
- Column Filter4 %
Row Filter (deprecated)4 %Row Splitter (deprecated)3 %- Excel Reader3 %
- RowID3 %
- Rule Engine2 %
- CSV Reader2 %
- Joiner2 %
Number To String1 %- Concatenate1 %
- Column Appender1 %
- Rule-based Row Filter1 %
Column Rename1 %- Column Expressions1 %
XLS Reader1 %Excel Reader (XLS)1 %Cell Splitter1 %- String Manipulation (Multi Column)< 1 %
- GroupBy< 1 %
Variable to Table Row< 1 %- File Reader< 1 %
- Math Formula< 1 %
String To Number< 1 %- Column Renamer< 1 %
- Column Rename (Regex)< 1 %
- Pivot< 1 %
- Column Splitter< 1 %
- Unpivot< 1 %
Concatenate (Optional in)< 1 %- Missing Value< 1 %
- Rule-based Row Splitter< 1 %
- Column Auto Type Cast< 1 %
Column Appender< 1 %- Number to String< 1 %
- Duplicate Row Filter< 1 %
- DB Query Reader< 1 %
- Table Row to Variable< 1 %
- Java Snippet< 1 %
- Column Resorter< 1 %
- Top k Row Filter< 1 %
- Column Renamer (Dictionary)< 1 %
- Case Converter< 1 %
- Column Combiner< 1 %
- Reference Column Resorter< 1 %
- Number Rounder< 1 %
- Constant Value Column Filter< 1 %
Numeric Scorer< 1 %- Partitioning< 1 %
- String to Number< 1 %
CASE Switch Data (End)< 1 %- Data Explorer< 1 %
- Row to Column Names< 1 %
- Create Table Structure< 1 %
- Reference Column Filter< 1 %
- Missing Value Column Filter< 1 %
- Sorter< 1 %
Excel Reader (XLS)< 1 %- Loop End< 1 %
Cell Replacer< 1 %- Table Manipulator< 1 %
File Reader< 1 %Table Reader< 1 %- Google Sheets Reader< 1 %
- DB Reader< 1 %
Table Column to Variable< 1 %- Cell Splitter< 1 %
- Double to Integer< 1 %
- Excel Writer< 1 %
- Regex Extractor< 1 %
Joiner< 1 %- Counter Generation< 1 %
- Date&Time to String< 1 %
- Reference Column Splitter< 1 %
Loop End< 1 %- Java Snippet Row Filter< 1 %
- Catch Errors (Data Ports)< 1 %
Variable Condition Loop End< 1 %- Column Merger< 1 %
- Normalizer< 1 %
- String Replacer< 1 %
- Rule Engine (Dictionary)< 1 %
- End IF< 1 %
- SDF Reader< 1 %
- JSON to Table< 1 %
- XPath< 1 %
Table Row To Variable Loop Start< 1 %Recursive Loop Start< 1 %- Line Reader< 1 %
CSV Reader< 1 %- Add Empty Rows< 1 %
- Column to Grid< 1 %
- Constant Value Column< 1 %
- Cross Joiner< 1 %
- Java Snippet (simple)< 1 %
- String Input (legacy)< 1 %
- String to Date&Time< 1 %
- Date&Time-based Row Filter< 1 %
- Empty Table Switch< 1 %
- Math Formula (Multi Column)< 1 %
- Table View (JavaScript)< 1 %
- Create Date&Time Range< 1 %
- Variable to Table Column< 1 %
- Row Filter (Labs)< 1 %
- Cluster Assigner< 1 %
- Table to JSON< 1 %
- CASE Switch End< 1 %
- Split Collection Column< 1 %
Database Connection Table Reader< 1 %- Loop End (Column Append)< 1 %
- Chunk Loop Start< 1 %
- Column List Loop Start< 1 %
- Group Loop Start< 1 %
- Column Aggregator< 1 %
- Domain Calculator< 1 %
- Nominal Value Row Filter< 1 %
- Reference Row Filter< 1 %
- Reference Row Splitter< 1 %
- String Splitter (Regex)< 1 %
- Row Sampling< 1 %
String Replace (Dictionary)< 1 %- Ungroup< 1 %
- Extract Table Spec< 1 %
- Color Manager< 1 %
- Empty Table Creator< 1 %
Excel Reader (XLS)< 1 %Table Column to Variable< 1 %List Files< 1 %- Lag Column< 1 %
- Nominal Value Row Splitter< 1 %
- Rank< 1 %
- Extract Table Dimension< 1 %
- Data Generator< 1 %
- SAS7BDAT Reader< 1 %
Read Excel Sheet Names (XLS)< 1 %- Column Filter (legacy)< 1 %
- Table Editor (JavaScript)< 1 %
- Python Source (legacy)< 1 %
- Date&Time to legacy Date&Time< 1 %
- Table Column to Variable< 1 %
- Variable to Table Row< 1 %
- File Reader (Complex Format)< 1 %
- Table Reader< 1 %
- Variable Creator< 1 %
- Random Forest Predictor (Regression)< 1 %
- DB Insert< 1 %
- DB Writer< 1 %
- Path to String< 1 %
- Python Script (legacy)< 1 %
- Auto-Binner< 1 %
- Row Splitter (Labs)< 1 %
- String Replacer (Dictionary)< 1 %
- Visualization Property Extractor< 1 %
- R Snippet< 1 %
Table Row to Variable< 1 %Merge Variables< 1 %- Case Converter< 1 %
- List Box Input (legacy)< 1 %
- Date&Time Shift< 1 %
- Merge Variables< 1 %
Python Script (1⇒1)< 1 %- Date&Time Difference< 1 %
Variable to Table Column< 1 %Line Reader< 1 %- RDKit Descriptor Calculation< 1 %
- RDKit From Molecule< 1 %
Table Extractor< 1 %- Try (Data Ports)< 1 %
- CASE Switch Start< 1 %
- Value Selection (legacy)< 1 %
- Columns to JSON< 1 %
- XPT Reader (Beta)< 1 %
Database Reader< 1 %- Cache< 1 %
- Molecule Type Cast< 1 %
- R to Table< 1 %
- Time Generator (legacy)< 1 %
- String to Date/Time (legacy)< 1 %
- Number Formatter< 1 %
- Create Collection Column< 1 %
- Try (Variable Ports)< 1 %
Database Writer< 1 %Loop End (2 ports)< 1 %Counting Loop Start< 1 %- Binner (Dictionary)< 1 %
- Column Comparator< 1 %
- Table Validator (Reference)< 1 %
- Equal Size Sampling< 1 %
- Filter Apply< 1 %
- String Manipulation (Variable)< 1 %
CASE Switch Data (Start)< 1 %- Parallel Chunk End< 1 %
- String Configuration< 1 %
JSON Reader< 1 %- Date/Time Shift (legacy)< 1 %
- Dropbox Search< 1 %
- Generic Loop Start< 1 %
- Shape Manager< 1 %
- List Box Configuration< 1 %
Variable to Table Column< 1 %Table Row to Variable< 1 %- ARFF Reader< 1 %
Database Looping< 1 %- Fixed Width File Reader< 1 %
Recursive Loop End< 1 %- Decision Tree Predictor< 1 %
K Nearest Neighbor< 1 %- MultiLayerPerceptron Predictor< 1 %
- One to Many< 1 %
- Table Validator< 1 %
Number To String (PMML)< 1 %- Statistics< 1 %
Python Script (1⇒1)< 1 %- R Source (Table)< 1 %
- Extract Time Window (legacy)< 1 %
- Moving Average< 1 %
- Time to String (legacy)< 1 %
- Molecular Properties< 1 %
- XLS Control Table Generator< 1 %
- Load Text Files< 1 %
- Extract Column Properties< 1 %
- Split Columns by Header< 1 %
- MolImporter< 1 %
- Unzip Files (legacy)< 1 %
- Wait...< 1 %
Variable to Table Row< 1 %Variable Loop End< 1 %- Logistic Regression Predictor< 1 %
- SMOTE< 1 %
- Numeric Binner< 1 %
- Expand Bit Vector< 1 %
- Category to Number< 1 %
- Edit Nominal Domain (Dictionary)< 1 %
- Edit Numeric Domain< 1 %
- Low Variance Filter< 1 %
- Denormalizer< 1 %
- Missing Value (Apply)< 1 %
- Number to String (PMML)< 1 %
- Numeric Row Splitter< 1 %
- Shuffle< 1 %
- Target Shuffling< 1 %
- Value Counter< 1 %
- IF Switch< 1 %
- SDF Inserter< 1 %
- External Tool< 1 %
- Index Query< 1 %
Excel Sheet Appender (XLS)< 1 %Excel Writer (XLS)< 1 %- Java IF (Table)< 1 %
- NGram Creator< 1 %
- Value Filter (legacy)< 1 %
- Double Input (legacy)< 1 %
- Integer Input (legacy)< 1 %
- Scatter Plot (JavaScript)< 1 %
- Container Input (JSON)< 1 %
- JSON to XML< 1 %
Python Script (1⇒2)< 1 %Python Script (2⇒1)< 1 %Extract Date&Time Fields< 1 %- Window Loop Start< 1 %
- Moving Aggregator< 1 %
XML Reader< 1 %- Row Splitter (col+)< 1 %
- Remove Empty Rows< 1 %
- Collection to String< 1 %
- Breakpoint< 1 %
Simple File Reader< 1 %Generic Loop Start< 1 %- Recursive Loop End< 1 %
- Variable Loop End< 1 %
- DBSCAN< 1 %
- Bootstrap Sampling< 1 %
- Table Difference Finder< 1 %
- Extract Color< 1 %
- DB Column Filter< 1 %
- Stop Word Filter< 1 %
- Decision Tree View (JavaScript)< 1 %
- Line Plot (JavaScript)< 1 %
- JSON Path< 1 %
- RDKit SMILES Headers< 1 %
- Date Extractor< 1 %
- Extract Text< 1 %
Views
- This node has no views
Workflows
!Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub- (3D) Fragment library design workflowKNIME Hub
- 00_Integer_Zero_Pad_Example_WorkflowKNIME Hub
- 00_Progress_Tracker_Supply_Logistics_ExampleKNIME Hub
- 00_Progress_Tracker_Supply_Logistics_ExampleKNIME Hub
- Show all 1092 workflows
Links
- How to change multiple columns elegant?by knimediger on 2019-10-31forum.knime.com/p/73731
- Renaming of lot of columnsby izaychik63 on 2018-09-14forum.knime.com/p/47703
- How to change first row to be column header and delete second rowby mlauber71 on 2019-10-28forum.knime.com/p/73356
- Promote Row 1 as column headersby qqilihq on 2019-09-04forum.knime.com/p/69313
- Change Column Header nameby tommy on 2020-06-13forum.knime.com/p/94239
- Show all 12 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.