Forum Discussion
Two Tables of same Data
HI, I have got Two tables of the Same Data (Same COlumns ), just the difference is between Past and Present Data.Each Table has about a million ROw, is there any way alternative rather than Ap...
Table of same Data
Previous Year Data from _ DataBase
Current Year Data From - Sharepoint Folder
I just want treat them as single table without Appending it, is there any alternative than Append
HI heygowtam,
If they has the same data structure, you can create a new query table with Table.Combine funciton to reference and combine two table records. Then you can turn off the source query tables loading in query edit and only load the merged table records.
Table.Combine - PowerQuery M | Microsoft Learn
Regards,
Xiaoxin Sheng