We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun 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