Results 1 to 2 of 2

Thread: Get Data From Folder and Merges

  1. #1
    Acolyte Nick Burns's Avatar
    Join Date
    May 2017
    Posts
    75
    Articles
    0
    Excel Version
    Office 365

    Get Data From Folder and Merges



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I'll be reading in hundreds of Excel files with multiple worksheets producing tens of thousands of rows. I'm merging this data with another table with 28,000+ rows for data validations.
    Currently I have this merge happening in the the Transform Query/Function - ie, the merge is happening per file.

    Would I gain any performance improvements if I move this merge after all the files have been combined?
    (this is all employee data, so sanitizing the data will be rather difficult)
    Oh... by the way, YOU'RE WELCOME!

  2. #2
    Acolyte Nick Burns's Avatar
    Join Date
    May 2017
    Posts
    75
    Articles
    0
    Excel Version
    Office 365
    Any thoughts?
    Oh... by the way, YOU'RE WELCOME!

Posting Permissions

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