topic Re: XML File Read in QlikView

XML File Read

Fri, 22 Nov 2013 19:47:32 GMT

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>

Re: XML File Read

Anonymous — Fri, 22 Nov 2013 20:00:06 GMT

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

Re: XML File Read

Fri, 22 Nov 2013 20:01:40 GMT

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?

Re: XML File Read

Mon, 16 Dec 2013 18:01:52 GMT

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 )