Database Insert Column Header (Legacy)

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 Predecessors

  • No recommendations found

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.

Installation

To use this node in KNIME, install the extension Vernalis KNIME Nodes from the below update site following our NodePit Product and Node Installation Guide:

v5.2

A zipped version of the software site can be downloaded here.

Plugin provider: Vernalis Research, UK
Plugin version: 1.36.5.v202312051850
On NodePit since: 2023-12-06
Last update: 2024-04-29
KNIME versions: v5.2, v5.1, v4.7, v4.6, v4.5

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!