QlikView's xml import utility is great if you have to bring in lots of the same kind of XML file. It doesn't work so well though if you have a lot of different types of xml files. Since XML is a W3C recommended standard I always thought it should be possible to make a script based on those standards that would logically parse any XML file.
That just what this does. It creates four tables as follows:
Files : A list of the files that were imported with path and generated ID
Hierarchy : A list of all XML elements their, hierarchy level, and their parent information
Values : A list of the XML values keyed back to their source element
Attributes : A list of the XML attributes keyed back to their source element
It's a first draft so I'm sure the script could be tightened up a bit and I may have missed some scenarios. I did throw if a few intentional malformed xml files and it even sorted those out. I thought I'd pass it on in case anyone else may have use of something like this. I checked around before I built it but I couldn't find anything like it.
I've attached a dummy XML document and the QVW where it's been imported.