I've recently had cause to dust off an application I built several years ago to extract geocodes (longitude and latitude) from address data. The application uses the MapQuest API to take a list of addresses or postcodes and return the relevant coordinates, which you can then output to CSV or Excel. I haven't seen a recent version of the API code on Qlikcommunity recently so I thought I'd share mine.
Step-by-step guide
All these instructions can also be found on the home screen of the QlikView app
- Open the attached file in QlikView desktop (note that you will need a licence)
- Obtain a key for the MapQuest API More details can be found here: MapQuest Developer Network . Paste your key into the box
- Create a single column CSV file with the column header "Address" listing all your address or postcode strings Type the name of this file into the relevant box
- Run the reload script whilst connected to the internet
- The results can be found on the "Data" tab, where you can export them to Excel or CSV
Note that each MapQuest account has a monthly limit for the number of requests it can submit (circa 10,000), so you may need to run the query in batches to get all your addresses.
