Google Maps Implementation Issue

[#1]

Hi All,

I am learning Qlikview and faced below issue while implementing google maps . I am using attached PDF as reference to do this scenario.

Code is as below :

Table1:

LOAD FirstName,

     LastName,

     City,

     ProductSold,

     Year

FROM

(ooxml, embedded labels, table is Sheet1);

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

for i=0 to $(noRows)

  let a=peek('FirstName',$(i),'Table1');

       let b=peek('LastName',$(i),'Table1');

       let c=peek('ProductSold',$(i),'Table1');

  let address=peek('City',$(i),'Table1');

Data:

  LOAD

  '$(a)' as FirstName,

  '$(b)' as LastName,

  '$(c)' as ProductSold,

  '$(address)' as Address

  ,subfield([Response/Placemark/Point/coordinates], ',' ,1) AS longitude,

  subfield([Response/Placemark/Point/coordinates], ',' ,2) AS latitude

  FROM [http://maps.google.com/maps/geo?q=$(address)&output=xml&oe=utf8&sensor=false] (XmlSimple, Table is [Data]);

next i;

[Siva_Sankar]

Hi Puneet,

What is the issue you are facing? Are there any error messae?

Can you explain?

[#3]

Issue is:  0 rows are getting fetched in the second step for each of the rows .

[Siva_Sankar]

Can you upload your qvw file?

[jpenuliar · Accepted solution]

the code in your Load section is using the old api.

Try Recode your Load script with the attached code.

[#6]

Thanks !!  It Worked .

Appreciate your quick help.