0 Replies Latest reply: Jun 7, 2016 8:46 AM by Kamil Lewandowski RSS

    Qlik Sense - getting administrative area info from geocoding google API

    Kamil Lewandowski

      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