Porstcode Checker

Gabocorreia95

HI all!

I've got a dataset with a field for postcode and i want to check that up with a list of valid UK  postcodes, to make sure that whatever rhe user has types there is correct.

I found a website where you can download a list of valid UK postcodes,whoever the file is to large to be opened in full with excel

https://www.doogal.co.uk/UKPostcodes

Any ideas on how i can achieve this?

Many thanks 

alexnajm

You should still be able to download it as a csv - just don’t open it. Go into Alteryx and try reading it in. You can then do what you need with it - perhaps you save it to a YXDB format for example!