Discussion board where members can learn more about Qlik Sense App Development and Usage.
I'm reading a table from SQL database
the table has a column of type xml
how can I parse this column in script? or is there another approach?
Here's the general idea:
SELECT Id, Name, Whatever, myxml from MyTable;
FROM FIELD (Rawdata, myxml) (XmlSimple, Table is [foo]);
The easiest way to generate the "blah" and "foo" bits is to save one of the "myxml" rows in an xml file and use the table files wizard to generate the xml load statement.
If the values in your xml column don't have an enclosing element, then you may need to fake one in as shown in this thread.
Need assistance for importing data with XML