Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

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 and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. 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

571 Views
0 Likes
0 Replies