Forum Discussion

robdan's avatar
robdan
Frequent Visitor
2 years ago

How to avoid duplicating tables when using "TABLE.COMBINE"

Hi, I have the following model view: many excel tables (each one containing data for 1 month, for 1 or multiple countries e.g."AUSTRIA_CORP_2403") with customer data all merged togheter (via TABLE...
Need Help
Anand24's avatar
Anand24
Icon for Super User rankSuper User
2 years ago

robdan ,
You can simply append all the tables in Power Query Editor (Transform Data/Edit Queries). There is an option to append 3 or more tables which you can use. The only issue would be when new month's table comes up when you will have to perform this append again.

robdan's avatar
robdan
Frequent Visitor
2 years ago

Do you mean the "Merge Queries" in the Home page of the edit query? That is what i'm using already by mergin as new.


My idea, in order to decrease the size of the report, would be to only keep the merged table 

  • Anand24's avatar
    Anand24
    Icon for Super User rankSuper User
    2 years ago

    robdan ,
    Not merge queries. Merge is Table.NestedJoin while append is Table.Combine. You need to append the various tables. Make sure all tables have same table structures.