Loading from XML

[Anonymous]

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

<Script>

<Script>

<Script>

<cmd>

</cmd>

</Script>

</Script>

</Script>

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

<Script>

<Script>

<cmd>

</cmd>

</Script>

</Script>

How do i handle this while loading the XMLs?

Regards,

Greeshma

[hariprasadqv]

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.

[avinashelite]

Hi Greeshma,

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

[amit_saini]

Hi,

Hope

this will help u:

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

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

Thanks,

AS

[Anonymous]

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

[#6]

you can try to fetch data through  WebFiles

[Anonymous]

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

[Anonymous]

Hi,

Any help on this?

Regards,

Greeshma

[buzzy996]

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

[Anonymous]

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.