Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Extract from XML MapQuest

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.

2 Replies
ashfaq_haseeb
Champion III
Champion III

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

Not applicable
Author

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