Qlik Community

GeoAnalytics

Discussion Board for collaboration regarding Qlik GeoAnalytics.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
eric_careta
Partner
Partner

join GeoAnalytics data with my country, region data

Hello everyone,

I have a problem with GeoAnalytics:

I need to load polygon and areas of many countries, administrative regions of level 1 and 2; and I use GeoAnalytics Connector with load operation to do that.

I try to develop a dummy app with inline tables to test that it works:

eric_careta_0-1628069399452.jpeg

But the problem is when I try to merge it with my main app. I load the Data of countryes with the three letters code (p.e. spain is 'esp' in my database and 'es' in the geoanalytics database), and the data of the regions are different too between my database and qlik database.

My question is if you know any way to merge my data with the qlik geoanalytics data or if the only way is update my database to change all codes to qlik format?

Thanks all!

 

Labels (2)
1 Reply
Patric_Nordstrom
Employee
Employee

Add another translation table is easier than updating the source table.

A spreadsheet with your names and qlik codes works fine.

Thanks

Patric