Community Halloween is live until October 31st! Complete any 2 quick activities to earn the 2025 Community Halloween badge. Feeling brave? Check out the activities here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Porstcode Checker

Gabocorreia95
7 - Meteor

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 

1 REPLY 1
alexnajm
18 - Pollux
18 - Pollux

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!

Labels
Top Solution Authors