This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We recently received some geolocation information in Easting/Northing format that cannot be readily geocoded in Alteryx right now. We've put together a batch macro which converts the long/lats using an R script, all ready for geocoding downstream. It's defined for the UK Ordance Survey National Grid but presume can be adjusted for other types:
Don't forget that you can also convert Eastings/Northings to a Spatial Object (Centroid) using the Create Points tool, and then pull the Lat/Long from a Spatial Info tool (Centroid X and Y properties).
I did some digging and found a really really good blog article from The Data School (and ultimately, @chris_love) that takes you through a slightly more detailed step-by-step instruction - much kudos to those guys!
Also, slightly off topic, but its worth remembering that you can change the projection of a non-WGS84 shape file on import too by changing the projection. Often a requirement in UK where shp files will be projected in British National Grid.