topic Re: Re: can qlikview do xml tansformation? in QlikView

can qlikview do xml tansformation?

Tue, 20 May 2014 01:52:56 GMT

If say i have xml file which need to be flatten by using other application before load in to the qlikview, is it possible to do the transformation and then load the file by just using qlikview?

Re: can qlikview do xml tansformation?

SergeyMak — Tue, 20 May 2014 02:05:51 GMT

yes

but the extent depends on the file structure

I think you could share file and explain the transformation requirements.

Than you will be able to get a clear answer

Re: can qlikview do xml tansformation?

Tue, 20 May 2014 02:25:14 GMT

This is the file i opened in xml notepad:

After i applied the xslt stylesheet, there only transform the "customfields"

sorry i dont know how to insert file i hope u can understand...

Re: can qlikview do xml tansformation?

SergeyMak — Tue, 20 May 2014 04:07:25 GMT

Unfortunately I don't.

to upload the file you can in the answer window select "Use advanced editor"

and please explain what you need to change in this xml file. What is your requirements?

Re: Re: can qlikview do xml tansformation?

Tue, 20 May 2014 06:05:00 GMT

SearchRequest was the xml file, output was the xml after flatten. usually, i have to use saxonica to complete transformation, however, i want to know that in qlikview, is there any way to transform xml and then load the file. i found a ELT qlikview connector, can use this to meet my requirement?

Re: Re: can qlikview do xml tansformation?

SergeyMak — Tue, 20 May 2014 06:10:55 GMT

in case of QLIKVIEW you shoul load the file and then do tansform.

I loaded file into qlikview. What you need to transform? What are the rules for transformation?

Re: Re: can qlikview do xml tansformation?

Tue, 20 May 2014 06:21:24 GMT

u checked the output file i insert? That was the final xml file after transformation. I just flatten the data under "customfields" tag. But the others never changed.