topic Re: reading xml in QlikView

reading xml

ali_hijazi — Wed, 11 Oct 2017 07:33:25 GMT

Hello

I'm reading a qvd file which contains data for a table that has a column whose data is in xml format

I'm reading the xml field and then parse it to get the fields in the xml tags along with their values

during reload I get an error saying

An invalid character was found in text content.

On line number: 1. On column number: 659.

but I don't have that number of columns?

Check attached QVW and QVD file

the script works fine if I put the condition where RecNo < 367

but if I remove this condition the script works fine - and I have to in order to read all data

can someone help me identify what might be wrong?

Re: reading xml

Abhiman — Thu, 25 Apr 2024 09:14:27 GMT

Most possibly the QVD file-structure doesn't fits to the Qlik rules of a valid XML. I think if you see the fields they have some unrecognised values for example '[[[[' , QLIK is unable to parse these delimited values and convert to XML.

You can try either 'delimited' or 'Fixed record' file format to see if it works.

Re: reading xml

marcus_sommer — Fri, 26 Apr 2024 13:29:31 GMT

Just load the qvd without any adjusting and then do a copy and paste of single cells and storing them into a file. Then using the load-wizard to load those files as xml. I assume some will fail and then you could look how they differ to a standard xml-structure.

Maybe it are only a few easy to fix adjustments - otherwise you should consider to skip the xml-load and loading + extracting it with a bunch of string-functions.