reading xml columns

[ali_hijazi]

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

[marcus_sommer]

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

- Marcus

[ali_hijazi]

what if there are more than one row with xml columns

any idea?

[marcus_sommer]

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

[ali_hijazi]

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

[marcus_sommer]

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

- Marcus