+ Reply to Thread
Results 1 to 2 of 2

Power Query - Append 2 tables from different workbooks

  1. #1
    Forum Contributor
    Join Date
    11-07-2014
    Location
    UK
    MS-Off Ver
    2010
    Posts
    128

    Power Query - Append 2 tables from different workbooks

    Hi all,

    I'm fairly new to power Query, I apologise if this isn't possible but it seems like should.

    I have two tables in excel, exact same name, format, columns etc. The only things that changes is the data within it and the amount of rows.

    I am trying to load the folder into power Query (as the folder will continually update) but it seems to be coming up with an error, could anyone help or point me in to a how to direction.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,705

    Re: Power Query - Append 2 tables from different workbooks

    https://www.xelplus.com/power-query-...-files-folder/
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Append and replace in Power Query
    By punter in forum Excel General
    Replies: 3
    Last Post: 04-08-2020, 01:25 AM
  2. [SOLVED] Append to a query in Power Pivot
    By punter in forum Excel General
    Replies: 8
    Last Post: 04-07-2020, 07:06 PM
  3. Power Query: Updating a query based on changing tables
    By cheesehead101 in forum Excel General
    Replies: 1
    Last Post: 12-16-2019, 06:54 PM
  4. [SOLVED] Append Data using Power Query
    By Howardc1001 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-24-2019, 10:26 AM
  5. Power query append?
    By pedroc in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-08-2018, 06:08 PM
  6. Power Query tables in VBA
    By orhanceliloglu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-26-2018, 08:25 AM
  7. Power Query - how to append tables
    By GIS2013 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-25-2015, 04:55 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1