join GeoAnalytics data with my country, region data
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:
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?