Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2016-06-07 08:12 AM

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

310 Views
0 Likes
0 Replies