Combining Tables that have same columns

KNIME Analytics Platform
#1

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)

#2

Hi @DetectiveHoban,

Welcome to the KNIME forum!

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

Best,
Martyna

1 Like
#3

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;
2 Likes
#4

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.