Forum Discussion

StasM's avatar
StasM
Regular Visitor
9 years ago
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...
  • BhaveshPatel's avatar
    BhaveshPatel
    9 years ago

    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.

     

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

StasM

 

You can also input the table names in Advanced Editor with power query to get the appended table.

 

Best Regards,

Herbert