topic Re: Loading from XML in QlikView

Loading from XML

Anonymous — Fri, 20 Mar 2015 04:38:46 GMT

Hi,

I am using XMLs as my data source. The tags in the XMLs are nested at different levels. When i load this using the table files wizard, QV creates 3 tables depending on the tags and keys to associate these tables. Multiple XMLs are being generated for the same test type. The level of nesting is bound to change.

Eg: For one test type the structure of the tags is as shown below

<cmd>

</cmd>

</Script>

the test type when run at a different timestamp can generate xml with below tags

<cmd>

</cmd>

</Script>

How do i handle this while loading the XMLs?

Regards,

Greeshma

Re: Loading from XML

hariprasadqv — Fri, 20 Mar 2015 04:46:11 GMT

Hi Greeshma.

I was faced same issue previously. i found a way to get it solved,i.e importing xml data into Excel and load Excel into Qlikview.

Re: Loading from XML

avinashelite — Fri, 20 Mar 2015 05:08:47 GMT

Hi Greeshma,

Can you please share the xml file and your app ???

Re: Loading from XML

amit_saini — Fri, 20 Mar 2015 05:10:53 GMT

Hi,

Hope

this will help u:

http://community.qlik.com/message/678264#678264

http://community.qlik.com/message/447061#447061

Thanks,

Re: Loading from XML

Anonymous — Fri, 20 Mar 2015 05:32:44 GMT

Hi Hariprasad,

Thanks for your response. The XML will be generated on a daily basis. It is not feasible to import to excel each time the XML is generated.

Regards,

Greeshma

Re: Loading from XML

Fri, 20 Mar 2015 05:34:33 GMT

you can try to fetch data through WebFiles

Re: Loading from XML

Anonymous — Fri, 20 Mar 2015 05:37:38 GMT

Hi Avinash,

I have attached XMLs with some sample data. I am planning to save the data into a qvd and then load it into the app. The XML will be generated whenever user runs a test.

Regards,

Greeshma

Re: Loading from XML

Anonymous — Mon, 23 Mar 2015 11:59:53 GMT

Hi,

Any help on this?

Regards,

Greeshma

Re: Loading from XML

buzzy996 — Mon, 23 Mar 2015 12:59:25 GMT

u can th this,

1. store ur xml file in ur local drive,

2.qlikview-edit-webfile-local file

3.select XML check box

and load

Re: Loading from XML

Anonymous — Tue, 24 Mar 2015 03:19:41 GMT

Thanks for your response but I know how to load the XML. The problem here is when the structure of the xml changes. I have explained this in the original post and also shared sample files.