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