Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

New Contributor III

Qlik Sense - getting administrative area info from geocoding google API

Hi guys. I'm implementing script module adding to my customer addresses list their latitude, longitude and administrative area data. With lat and long- I don;t have any problem because it is in one table. But- administrative data not.

Geocoding google API give me back very inefficient xml table

Developer's Guide  |  Google Maps Geocoding API  |  Google Developers

So I guess I would need to join those tables and crosstable the result, but key field (%Key_address_component_3D78D9B402C68EA5) which define what "lone_name" is according to is not distinct.

I could make mapping table and load results few times but it would totally increase number of query and slow down whole app.

Any ideas? Thanks in advance