1 Reply Latest reply on Nov 7, 2012 6:47 AM by Shawn Wallwork

    Table and country codes from a xls file

    Gobo Hormigo

      Thats should be something easy, but I'm getting crazy with it. I've got two tables in my xls file, first contains the name of each country and for each country some values per year, something like this:

       

      YearAfganistanAlbania
      2001

      2002

      2003

       

       

      And on the other, a list with each country name and its ISO code to be mapped.    When I try to connect both tables I don't know how to proceed, cause I have a list of country names to be mapped with a dimension "country name". I 've tried  to write a new column that contains all the countries and connect it, but it takes the first column "Afganistan". What's the correct way to do this?    Thanks for your help