How to get latitude and longitude values from Tableau

by Laine Caruzca

How to get latitude and longitude values from Tableau

A new trick I learn this week is how to get the latitude and longitude values from Tableau. This is a useful tool for when you might want to join/union two data sets by country in Alteryx, but the country names are in various formats.

 

  1. Drag the ‘Country’ field into the view. A map should show automatically with all the points. Select all countries by using Ctrl + A. Then right click and select ‘View Data’.
  2. You should then see a box that looks something like this.
  3. Then select ‘Export All’. You can then save this file onto your computer and union this file with the original file to get the lat and long latitudes for each country.
  4. You can then do this process again to get the lat and long values from the other data sets. Once you’ve got all the data from both files, you can then union/join these together using Alteryx and voila, you’ve managed to get around the problem!
API Pagination in Alteryx

3 mins read

Sun 04 Nov 2018

Dashboard Week Day 5: Toilets toilets toilets

1 mins read

Sat 18 Aug 2018

Dashboard Week Day 4: Major League Baseball

2 mins read

Thu 16 Aug 2018

Dashboard Week Day 3: Food Standards Agency

2 mins read

Wed 15 Aug 2018