Nick Burns
Member
- Joined
- May 24, 2017
- Messages
- 162
- Reaction score
- 0
- Points
- 16
- Excel Version(s)
- Office 365
This more of a Best Practice/Performance question:
I'm reading Excel workbooks from a folder (100+ and growing).
I have to merge/compare data with two tables from a Master File (one table has 25K rows and growing, the other 900 rows and growing)
Is it better to do the comparison on the Sample Query or on the accumulated query (where all the workbooks have been loaded)?
I'm reading Excel workbooks from a folder (100+ and growing).
I have to merge/compare data with two tables from a Master File (one table has 25K rows and growing, the other 900 rows and growing)
Is it better to do the comparison on the Sample Query or on the accumulated query (where all the workbooks have been loaded)?