Forum Discussion

heygowtam's avatar
heygowtam
Icon for Helper II rankHelper II
3 years ago

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...
Need Help
heygowtam's avatar
heygowtam
Icon for Helper II rankHelper II
3 years ago

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 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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