DB Insert Column Header

This node renames the output columns of a database connection based on the values in a reference table. The underlying database is not affected. Missing values and empty strings are ignored in both input columns. When a lookup occurs more than once, the first valid pairing only is used

This node was developed by Vernalis Research . For feedback and more information, please contact knime@vernalis.com


Lookup Column
The name of the column with the incoming names
Value Column
The name of the column with the new names
Missing Column Behaviour
This setting governs how the node should behave if an incoming column name is not present in the lookup column

Input Ports

Database connection
The lookup table, with lookup and new value columns

Output Ports

Database connection with renamed columns

Popular Predecessors

Popular Successors

  • No recommendations found


This node has no views


  • No workflows found



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.