Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • Nodes
  • DB Insert Column Header
NodeNode / Manipulator

DB Insert Column Header

Community Nodes Vernalis Databases DB
Drag & drop
Like
Copy short link

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

Node details

Input ports
  1. Type: DB Data
    Database connection
    Database connection
  2. Type: Table
    Lookup table
    The lookup table, with lookup and new value columns
Output ports
  1. Type: DB Data
    Database connection
    Database connection with renamed columns

Extension

The DB Insert Column Header node is part of this extension:

  1. Go to item

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Business Hub
© 2023 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits