Forum Discussion

Ortignano's avatar
Ortignano
Helper II
5 years ago
Solved

Append data to the same table

Hi,

 

I have an excel file with Master data within a Table that I loaded in powerquery as connection only.

I would append to Master data another table and load them in Excel Master Data table and not in another table

Is it possible?

Thanks

Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi Ortignano 

     

    Yes, it's possible. Open the Master Data Excel file and launch the Power Query Editor. Add the second table as a query (e.g. Sheet4 in below image). Then select the Main query, click on Append Queries. Then select Sheet4 in the pop-up dialogue and append it to the current Main query. After that, click on Close & Load. It will load these two queries to the Master Data Excel file by default.

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.

1 Reply

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    5 years ago

    Hi Ortignano 

     

    Yes, it's possible. Open the Master Data Excel file and launch the Power Query Editor. Add the second table as a query (e.g. Sheet4 in below image). Then select the Main query, click on Append Queries. Then select Sheet4 in the pop-up dialogue and append it to the current Main query. After that, click on Close & Load. It will load these two queries to the Master Data Excel file by default.

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.