Forum Discussion
Solved
Update data via merge/adding excel tables
Hi guys, Could you please clarify, how to combine/add/merge amount of data tables with same columns. Example: I have weekly results of sales. Let's suppose with 3 columns: data, salesman, rev...
Yes, You can add it into your table using append table operation in the Query Editor.
You can watch this VIDEO to understand how it works.
Hi StasM
As long as you've got the same number of columns, consistent data types and columns are in the same order, simply append new tables to the one in your data model using Query Editor. Either click Append Queries in Home Tab or use Advanced Editor in View Tab
FYI, Merge is join while Append is union.
Cheers