Nick Burns
Member
- Joined
- May 24, 2017
- Messages
- 162
- Reaction score
- 0
- Points
- 16
- Excel Version(s)
- Office 365
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)
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)