Results 1 to 1 of 1

Power Query, merge 2 or more large files in one

Threaded View

  1. #1
    Registered User
    Join Date
    03-16-2012
    Location
    Russia
    MS-Off Ver
    Excel 2010
    Posts
    98

    Power Query, merge 2 or more large files in one

    Help pls with Power Query. Sorry for 2nd post, but here is db problem

    15 local copies of the one original file for filling to the employees.

    Next after filling i need combine all files in to one table.

    How to do it? And what if there are conflicting data? It is necessary to show in a summary table, which fields and which files there are conflicts, to give these files for rechecking managers. Maybe any example for 2 tables in different files?

    Data.zip - file PQ_original.xlsx - file for filling.
    PQ4 query 1.xlsx and PQ4 query 2.xlsx - files from employes. Need combine to one.

    PQ_all.xlsx - the same, just example all in one sheet (real files very large, so, real structure is in the "Data" folder).
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Power Query, merge 2 or more large files in one
    By Remphan in forum Excel General
    Replies: 0
    Last Post: 03-02-2016, 03:30 AM
  2. Replies: 2
    Last Post: 07-19-2015, 06:04 PM
  3. VBA and Power Query
    By Brawnystaff in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-16-2015, 05:10 AM
  4. Power Query TNS Settings
    By Nerdio in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-26-2015, 08:24 AM
  5. power point query
    By jrmehta in forum Excel General
    Replies: 1
    Last Post: 10-11-2010, 01:58 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