Combining Tables that have same columns

[DetectiveHoban]

Had a question about how to combine multiple tables that have the same columns.
( hoping that the end result is just 1 table with all the rows from the previous two tables)

[Martyna]

Hi @DetectiveHoban,

Welcome to the KNIME forum!

I think the Concatenate node (or Concatenate (optional in)) might help.

Best,
Martyna

[bve]

If you are getting the data direct from a db it’s probably better use sql to perform a union for you.

SELECT City FROM Customers
UNION
SELECT City FROM Suppliers
ORDER BY City;