topic Re: Extract from XML MapQuest in QlikView

Extract from XML MapQuest

Tue, 15 Jul 2014 10:05:14 GMT

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

I have the following XML:

<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 — Tue, 15 Jul 2014 10:13:40 GMT

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

Tue, 15 Jul 2014 12:58:36 GMT

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