1 Reply Latest reply on Jun 19, 2018 8:02 AM by Donna Coles

    Merging Files: Excel and Shapefile

    Robin Simpson-McKay

      Hello Everyone,

       

      I have been trying to marry two sets of data. One, a shapefile of polygons of neighborhoods in Toronto, the other an excel file with some data on these neighborhoods (average resident age, housing prices, etc.). Ideally would like to be able to sort the polygon types by the information in the excel. I have tried to join and union the data sets, but despite having the same columns of "Neighbourhood" and "Neighbourhood ID", they don't seem to be able to communicate.

       

      Has anyone had any success with this? Is there a step I am missing to make the data more compatible between the two types?

       

      Thank you

        • 1. Re: Merging Files: Excel and Shapefile
          Donna Coles

          Hi Robin

           

          A couple fo things to double check - are the fields that look like they have the same names actually the same datatype and the same capitalisation/spelling?  Sometimes an ID field might get interpreted as a string in one data set but a number in another, and Tableau won't be able to join/blend them. Similarly Id is not the same as ID.

           

          If it isn't this simple, might be worth attaching a copy of the two files you're trying to combine.

           

          Donna

           

          PS - am also moving this post into the main Forums (Forums ) area of the Community, where it will attract more attention.

          1 of 1 people found this helpful