Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

ali_hijazi
Not applicable

parse xml columns in qlik sense

Hello

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?

kindly advise

1 Reply
rwunderlich
Not applicable

Re: parse xml columns in qlik sense

Here's the general idea:

Rawdata:

LOAD *

;

SELECT Id, Name, Whatever, myxml from MyTable;

xmldata:

LOAD

     blah

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

-Rob

http://masterssummit.com

http://qlikviewcookbook.com