Some of our postcodes are currently entered manually, which often leads to errors. These mistakes affect our data quality because incorrect postcodes prevent the longitude and latitude data from being picked up correctly.
Although the business already has validation checks, there are still cases where postcodes need to be fixed manually. With the large volume of data we handle, this isn’t practical. We’d like to move this validation into Qlik Sense using a script.
We need a solution that can identify:
postcodes that are in the wrong format, and
postcodes that are in the correct format but do not actually exist.
Does anyone have any suggestions on how we could achieve this?
but if there is validation of non existing that maybe harder to achieve as there is approx 4000 new postcode each month added so you need almost live update to your checks.
