Insert rows from another table

Question

Hi.&nbsp;This might be simple, but I don't know how to do this.&nbsp;I have two facttables with&nbsp;similar data where I want data from one table to be inserted in the other. When I do a merge the columns is added, but I don't want more columns. The two tables consists of four columns; Article, Date, UnitInStock, FullCost. So I would like to merge all rows into one table in the Query Editor.&nbsp;&nbsp;

ankitpatira · Accepted Answer

Tormod_GK&nbsp;Instead of Merge use Append Queries and make sure column names are same in both the tables.

Forum Discussion

Insert rows from another table

2 Replies

Related content

merge or update/insert lakehouse table from another lakehouse table

Identity Insert On Warehouse table

Inserting Subtotals in a Table

Table insert / rows to group

Insert intermediary rows on matrix table