+ Reply to Thread
Results 1 to 4 of 4

Merge Pro tip in Power Query

  1. 06-28-2021, 03:23 PM #1
    hudson andrew
    hudson andrew is offline
    Forum Contributor
    Join Date
    05-04-2016
    Location
    London
    MS-Off Ver
    MS Office Excel 2010/2013
    Posts
    354

    Merge Pro tip in Power Query

    Hi All,

    My greeting to all the experts here in the forum , can some one pleSe hlep me how can i please make my merge process quick in power query .

    I have tow tables data sourced from Csv.files and each files contains 400 K plus rows of data , when i am doing merge process between both files to filter out old and new .. during that process query refresh is taking ages to complete cause of i am adding a merge step.

    Can some one help me how i can make the query refresh faster .. i could not upload the files cause those are massive to upload .
    Reply With QuoteRegister To Reply
  2. 06-29-2021, 12:03 AM #2
    hudson andrew
    hudson andrew is offline
    Forum Contributor
    Join Date
    05-04-2016
    Location
    London
    MS-Off Ver
    MS Office Excel 2010/2013
    Posts
    354

    Re: Merge Pro tip in Power Query

    all, please ignore the post .. i have posetd the query in MR excel forum ..
    Reply With QuoteRegister To Reply
  3. 06-29-2021, 12:15 AM #3
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,877

    Re: Merge Pro tip in Power Query

    As per the forum rules, please provide a LINK to the post on Mr Excel.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  4. 06-29-2021, 03:53 AM #4
    hudson andrew
    hudson andrew is offline
    Forum Contributor
    Join Date
    05-04-2016
    Location
    London
    MS-Off Ver
    MS Office Excel 2010/2013
    Posts
    354

    Re: Merge Pro tip in Power Query

    Hi All, i have cross posted the same question at the following link .

    https://www.mrexcel.com/board/thread.../#post-5714520
    Last edited by hudson andrew; 06-29-2021 at 03:55 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Power Query - Append and merge tables
    By DystopiaRelic in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-13-2021, 02:42 PM
  2. Power Query Merge only the First Instance
    By c4revolution in forum Excel General
    Replies: 1
    Last Post: 04-13-2021, 04:35 AM
  3. new entry in merge power query
    By rosscortb in forum Excel General
    Replies: 1
    Last Post: 04-24-2020, 05:02 AM
  4. Power query merge column
    By Eric Tsang in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-17-2020, 09:08 AM
  5. Power Query Merge Columns if Not Null
    By brent_milne in forum Excel General
    Replies: 1
    Last Post: 01-26-2020, 11:41 AM
  6. Merge Sheets Power Query
    By morerockin in forum Excel General
    Replies: 8
    Last Post: 04-11-2017, 08:17 AM
  7. Power Query, merge 2 or more large files in one
    By Remphan in forum Excel General
    Replies: 0
    Last Post: 03-02-2016, 04:28 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1