3 Replies Latest reply on Sep 30, 2019 5:56 AM by Ciara Brennan

    Connecting files with country names from different languages

    Frank Brenner

      Hello everybody,

       

       

      I need some help with the following task: I want to connect two csv (Daten.csv and Income.csv) files which contain data on country level. Both files are held very basic - one row with the country name and one row with data values.

      Daten.csv is coming from a German website, therefore names in the first row are in German:

      Daten_German.PNG

      Income_per_person_gdp.csv is coming from an English website, therefore names in the first row are in English:

      Daten_English.PNG

      Tableau can handle both files seperately very well and recognize the country level data and build maps from the data, but I can't seem to connect both datasets.

      My current Workaround is including a third table ("Ländernamen") which is translating the Country names between German and English, but I guess there must be a better way of solving this.

      Tableau_Connect_CountryNames.PNG

      Is there any function in Tableau, that is able to connect both data sets with automatically knowing, that "Italy" = "Italien" and "Iraq" = "Irak", etc ...

       

      Kind regards,
      Frank