Extract from XML MapQuest

[#1]

Hi Guys, I have a small question related to MapQuest.

I have the following XML:

<response>

     <results>

          <result>

               <location>

                    <adminArea6 type="Neighborhood"/>

                    <adminArea5 type="City">London</adminArea5>

               </location>

          </result>

     </results>

</response>

I'm trying to extract London from there. My path is [results/result/locations/adminArea5] as City, but I get the following error:

Field not found - <results/result/locations/adminArea5>.

Could you help me solve this issue?

Thanks,

Adrian

PS: I have the free version of QV, so I would appreciate if you would explain me by writing and not by sending files.

[ashfaq_haseeb]

Hi,

Use the attached xml and below script in QlikView file.

Directory;

// Start of [Test.xml] LOAD statements

location:

LOAD adminArea5,

    [adminArea5/type],

    [adminArea6/type]

FROM [..\Desktop\Test.xml] (XmlSimple, Table is [response/results/result/location]);

// End of [Test.xml] LOAD statements

Regards

ASHFAQ

[#3]

Hi Ashfaq,

I don't get the errors now but there is no data. I'm using Mapquest API. Any thoughts why there is no data pulled?

Thanks