topic Re: reading xml columns in QlikView

reading xml columns

ali_hijazi — Tue, 02 Feb 2016 10:19:32 GMT

Hello

Got a SQL table that has a column of data type XML

all the records have the same schema for the xml column

what is the easiest way to read all the records' xml content as table in Qlik

Please advise

Re: reading xml columns

marcus_sommer — Tue, 02 Feb 2016 14:19:31 GMT

Have a look here: Re: Re: How to extract data from xml stored in a database

- Marcus

Re: reading xml columns

ali_hijazi — Wed, 03 Feb 2016 07:32:23 GMT

what if there are more than one row with xml columns

any idea?

Re: reading xml columns

marcus_sommer — Wed, 03 Feb 2016 07:48:07 GMT

I'm not sure - I would probably handle each one separate in the above mentioned way or maybe by storing them into separate xml-textfiles which then could be read per table-wizard. If the content of each xml isn't unique to the other data you will need some kind of key to identify them respectively to connect them in the right way to your other data.

- Marcus

Re: reading xml columns

ali_hijazi — Wed, 03 Feb 2016 08:55:27 GMT

the content of each xml is unique in terms of structure (tags)

so you mean I have to find a way to export each row's xml column to xml file then using a loop and benefiting from the script generated by the wizard I can read the xml files and transform the data into tabular structure in Qlik

-Ali

Re: reading xml columns

marcus_sommer — Wed, 03 Feb 2016 09:00:15 GMT

Yes, this was meant and if you need some meta-information about each xml you could code this within the filename of them.

- Marcus