6 Replies Latest reply on May 5, 2018 1:58 PM by Don Wise

    Join spatial file and excel file correctly

    Manuel Cervera

      Hi.

       

      I am trying to map poverty rates and other determinants related to poverty by state in a map of Mexico (see "Mapping example" attach as an example of what I am trying to do). I also have a database in excel file (attached) with the information and a spatial file (attached).

       

      I joined both spatial and excel files and I could do it successfully with the join clause: "Clave de entidad" y "Cve Ent". Nonetheless, when I start working on the sheet, I cannot find the way to see what is the different levels of poverty by state (I moved, for example, the "porcentaje pobreza 2010" measure to the color mark). The whole Mexico map is still in blue without any difference. Can you help me to find what I am doing wrong?

       

      Thank you in advance for your help.

       

      Regards,

       

      Manuel