can qlikview do xml tansformation?

[#1]

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?

[SergeyMak]

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

[#3]

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...

[SergeyMak]

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?

[#5]

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?

[SergeyMak]

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

So

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

[#7]

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.