Forum Discussion

Tormod_GK's avatar
Tormod_GK
Frequent Visitor
10 years ago
Solved

Insert rows from another table

Hi.   This might be simple, but I don't know how to do this.   I have two facttables with similar data where I want data from one table to be inserted in the other. When I do a merge the columns ...
  • ankitpatira's avatar
    ankitpatira
    10 years ago

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

ankitpatira's avatar
ankitpatira
Icon for Community Champion rankCommunity Champion
10 years ago

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

Tormod_GK's avatar
Tormod_GK
Frequent Visitor
10 years ago

Thanx! I did try append queries, but the clue here (as you mentioned) was to rename the columns so they were the same.