2 Replies Latest reply on Feb 23, 2016 1:22 PM by Srikanth R

    Data Interpreter Issues Geonames export file

    Srikanth R

      Hi All,

       

      I am trying to import the Geonames(Country Code / Zip / State / Lat and Long ) tab delimited file into the Tableau 9.1.1 .

       

      Tableau Data Interpreter is not reading/interpreting  the file right . Below is the link to the file and the comparison

       

      http://download.geonames.org/export/zip/allCountries.zip

       

      The data format is tab-delimited text in UTF-8 encoding( Unix Format), with the following fields :

       

      country code : iso country code, 2 characters

      postal code : varchar(20)

      place name : varchar(180)

      admin name1 : 1. order subdivision (state) varchar(100)

      admin code1 : 1. order subdivision (state) varchar(20)

      admin name2 : 2. order subdivision (county/province) varchar(100)

      admin code2 : 2. order subdivision (county/province) varchar(20)

      admin name3 : 3. order subdivision (community) varchar(100)

      admin code3 : 3. order subdivision (community) varchar(20)

      latitude : estimated latitude (wgs84)

      longitude : estimated longitude (wgs84)

      accuracy : accuracy of lat/lng from 1=estimated to 6=centroid

       

      Textpad interpretation of the file ( Same file saved as UTF-8 PC format)

       

      ADAD100Canillo42.58331.66676
      ADAD200Encamp42.53331.63336
      ADAD300Ordino42.61.556
      ADAD400La Massana42.56671.48336
      ADAD500Andorra la Vella42.51.56
      ADAD600Sant Julià de Lòria42.46671.56
      ADAD700Escaldes-Engordany42.51.56676
      AR3636POZO CERCADO (EL CHORRO (F), DPTO. RIVADAVIA (S))SALTAA-23.4933-61.92673

       

      Below is the Tableau Interpretation

      F1F2F3F4F5F10F11F12
      ADnullCanillonullnull42.58331.66676
      ADnullEncampnullnull42.53331.63336
      ADnullOrdinonullnull42.60001.55006
      ADnullLa Massananullnull42.56671.48336
      ADnullAndorra la Vellanullnull42.50001.50006
      ADnullSant Julià de Lòrianullnull42.46671.50006
      ADnullEscaldes-Engordanynullnull42.50001.56676
      AR3,636POZO CERCADO (EL CHORRO (F), DPTO. RIVADAVIA (S))SALTAA-23.4933-61.92673