1 Reply Latest reply on Aug 27, 2018 8:02 AM by Kent Marten

    Connecting Spatial File to Regional Data

    Jed Blankson
    Jed Blankson Aug 25, 2018 10:23 AM

      Hi I have obtained spatial data on the various regions in the UK which I have successfully managed to connect to tableau however I seem to be having trouble with connecting this to data to regional data on excel in order to show the excel data on a spatial map.

       

      I have followed various tutorials on youtube and on the tableau gallery regarding connecting to spatial data however the spatial data doesn't seem to recognize the excel data when I have tried to add a new connection.

       

      My excel data looks something similar to this:

       

      2008/09
      		2009/10
      		2010/11
      		2011/12
      North West535674674564
      North East573748748898
      East of England237435435345
      London4000550080007089

       

      I have spatial data for each of these regions but the data doesn't show up on the map when I have tried to add a new connection. I have followed the steps in the connecting to spatial maps video on this page: Resources | Tableau Public , however I cannot gss code to code as these do not show up on the connections drop down menu.

       

      Any help would be much appreciated!! I have been struggling for hours. Thanks

      • 126 Views
      • Categories: Calculations, Data Sources & Connections, Dates & Times, Extracts, Formatting & Display, Maps & Geocoding, Views & Dashboards, About Tableau Products, Tableau Online, Tableau Public
      • Tags:
        • 1. Re: Connecting Spatial File to Regional Data
          Kent Marten
          Kent Marten Employee Aug 27, 2018 8:02 AM (in response to Jed Blankson)

          Hi Jed Blankson,

           

          Is it possible for you to share the data? I'm not 100% certain what it is you are doing and how you are trying to do it based on what you've written above.

          If you are failing to join a spatial file to an excel table and you have matching attribute values - it's difficult to troubleshoot without the data.

          I would ensure you have no leading or trailing spaces in the values you are using to join.

           

          Thanks,

          Kent M.