XML File Read

[#1]

I have an xml file which looks like the below.  Can someone tell me how to load this into Qlikview so that the data between the data tags creates new records(rows) so that my end result is a table with 3 rows with id's: 1, 2, and 3

<?xml version="1.0" encoding="UTF-8"?>
<apiresult>
   <result_ok>1</result_ok>
   <total_count>1325</total_count>
   <page>1</page>
   <total_pages>27</total_pages>
   <results_per_page>50</results_per_page>
<data>
   <_0>
      <id>1</id>
      <contact_id/>
      <status>Deleted</status>
   </_0>
   <_1>
      <id>2</id>
      <contact_id/>
      <status>Open</status>
   </_1>
   <_2>
      <id>3</id>
      <contact_id/>
      <status>Complete</status>
   </_2>

</data>
</apiresult>

[Anonymous]

Martha

In the QV Desktop script editor:

•      Click the <Table Files> button
•      Select your file
•      Choose File Type of XML
•      Carry on following the prompts............

Best Regards,     Bill

[#3]

Hi Bill,

I tried that and unless I am doing something wrong, it doesn't parse it out.  If it works for you, can you send me the load statement?

[#4]

It coming as single Record. with the prefix of tag names for each field.

Are you expecting Qlikview to understand as 3 records ? ( Like in any another Tools )