Qlik Community

Qlik GeoAnalytics Discussions

Discussion Board for collaboration regarding Qlik GeoAnalytics.

Highlighted
ramonarcusa36
New Contributor III

Get list of GeoAnalytics countries in a different language

Hi guys.

I would like to use GeoAnalytics Connector to fix unresolved countries in my app. I just wanted to make a query using the Load Operation to get the list of countries in the Qlik system, so I can check out the correspondence with the names in my system.

My problem is that I'm getting the English name for the countries and I need those names in Spanish, because that's how they're stored in our system.

Is there any way to customize the language of data retrieved with Connector? Any other workaround?

Thanks in advance.

1 Reply
Employee
Employee

Re: Get list of GeoAnalytics countries in a different language

No, export in QGA connector Load is only possible with the English name.

Many of the alternative names are coming from geonames.org, use their API to retrieve the Spanish names. An account (free) is required to make the call.

http://api.geonames.org/countryInfoCSV?lang=es&username=demo

 

Thanks,

Patric