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 [e-mail]

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