Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
eric_careta
Partner - Contributor III
Partner - Contributor III

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