Forum

Notifications
Clear all

Searching very large files

6 Posts
2 Users
0 Reactions
95 Views
(@robbieg)
Posts: 39
Trusted Member
Topic starter
 

Hi there Philip and Mynda - Happy New Year!

I have downloaded the UK PAF (Postcode Address File) with 29million rows split into 6 separate files and want to use it to look up several thousand postcodes I have in another workbook and return the street address. If the PAF was (a lot) smaller I would just use XLOOKUP, so what tools do I need in order to achieve this?

Many thanks

Robert

 
Posted : 01/01/2022 3:45 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Robert,

I would put all 29 million rows in a single CSV file. Use Power Query to get the CSV file and do the lookup in Power Query using Merge Tables.

Mynda

 
Posted : 01/01/2022 8:25 pm
(@robbieg)
Posts: 39
Trusted Member
Topic starter
 

Thank you, Mynda. I'll give that a try.

All best wishes to you, Philip and your great team.

 
Posted : 02/01/2022 10:07 am
(@mynda)
Posts: 4761
Member Admin
 

Thanks, Robert! And you to 🙂

 
Posted : 02/01/2022 9:26 pm
(@robbieg)
Posts: 39
Trusted Member
Topic starter
 

Just to confirm that answer regarding the 29 million rows worked a treat. Thanks again.

 
Posted : 12/01/2022 2:35 pm
(@mynda)
Posts: 4761
Member Admin
 

Great to hear! Thanks for letting us know.

 
Posted : 12/01/2022 7:46 pm
Share: