2 Replies Latest reply: Dec 9, 2013 8:27 AM by jagan mohan rao appala RSS

    EXTRACT GOOGLE lat and lng using QV script

    Agnivesh Kumar

      I an trying to extract google lat and lng using following script , but it gives error : [result/geometry/location/lng]  not found

       

      address:

      LOAD A as Address

      FROM

      [C:\Users\agnivesh\Desktop\new address.xlsx]

      (ooxml, no labels, table is Sheet1);

       

       

      let noRows = NoOfRows('address')-1;

      for i=0 to $(noRows)

       

       

      let a=peek('Address',$(i),'address');

       

       

      Data:

      LOAD

      '$(a)' as Address,

      [result/geometry/location/lng] AS longitude,

      [result/geometry/location/lat] AS latitude

      FROM [http://maps.googleapis.com/maps/api/geocode/xml?address=$(a)&sensor=false];

       

      drop Table address;

       

       

      Please help