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

Options

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

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

Output Ports

Icon
Database connection with renamed columns

Popular Successors

  • No recommendations found

Views

This node has no views

Workflows

  • No workflows found

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.