Hub
Pricing About
NodeNode / Manipulator

DB Concatenate

DBQuery
Drag & drop
Like

This node concatenates two database tables. The table at inport 0 is given as the first input table (top input port), the table at inport 1 is the second table, resp. Columns with equal names are concatenated (if the column types differ the column type is the common base type of both input column types). If one input table contains column names that the other table does not, the columns can either be filled with missing values or filtered out, i.e. they will not be in the output table.

Node details

Input ports
  1. Type: DB Data
    First DB Data to concatenate
    First DB Data Table to concatenate.
  2. Type: DB Data
    Second DB Data to concatenate
    Second DB Data Table to concatenate..
Output ports
  1. Type: DB Data
    Concatenated DB Data
    Concatenated DB Data tables.
input (Dynamic Inport)
Additional DB Data Tables to concatenate.
  1. Type: DB Data

Extension

The DB Concatenate node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
  2. Go to item
  3. Go to item

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits