topic Qlik Sense - getting administrative area info from geocoding google API in App Development https://community.qlik.com/t5/App-Development/Qlik-Sense-getting-administrative-area-info-from-geocoding/m-p/1141611#M20225 <HTML><HEAD></HEAD><BODY><P>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.</P><P>Geocoding google API give me back very inefficient xml table</P><P><A href="https://developers.google.com/maps/documentation/geocoding/intro#GeocodingResponses" title="https://developers.google.com/maps/documentation/geocoding/intro#GeocodingResponses">Developer's Guide&nbsp; |&nbsp; Google Maps Geocoding API&nbsp; |&nbsp; Google Developers</A></P><P></P><P><IMG __jive_id="127085" alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/127085_pastedImage_2.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P><IMG __jive_id="127086" alt="" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/127086_pastedImage_3.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>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.</P><P>I could make mapping table and load results few times but it would totally increase number of query and slow down whole app.</P><P></P><P>Any ideas? <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> Thanks in advance</P></BODY></HTML> Tue, 07 Jun 2016 12:12:20 GMT Anonymous 2016-06-07T12:12:20Z Qlik Sense - getting administrative area info from geocoding google API https://community.qlik.com/t5/App-Development/Qlik-Sense-getting-administrative-area-info-from-geocoding/m-p/1141611#M20225 <HTML><HEAD></HEAD><BODY><P>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.</P><P>Geocoding google API give me back very inefficient xml table</P><P><A href="https://developers.google.com/maps/documentation/geocoding/intro#GeocodingResponses" title="https://developers.google.com/maps/documentation/geocoding/intro#GeocodingResponses">Developer's Guide&nbsp; |&nbsp; Google Maps Geocoding API&nbsp; |&nbsp; Google Developers</A></P><P></P><P><IMG __jive_id="127085" alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/127085_pastedImage_2.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P><IMG __jive_id="127086" alt="" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/127086_pastedImage_3.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>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.</P><P>I could make mapping table and load results few times but it would totally increase number of query and slow down whole app.</P><P></P><P>Any ideas? <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> Thanks in advance</P></BODY></HTML> Tue, 07 Jun 2016 12:12:20 GMT https://community.qlik.com/t5/App-Development/Qlik-Sense-getting-administrative-area-info-from-geocoding/m-p/1141611#M20225 Anonymous 2016-06-07T12:12:20Z