XML in a CLOB

william_denholm — Wed, 25 Nov 2020 16:16:04 GMT

We have XML stored in a CLOB on our database. We can query the DB and store the CLOB in a QVD with no issues.

When we go to load the CLOB, I want to be able to parse/split the XML in to fields. Some searching on here has brought to textbetween. This works fine for one record in the XML but we have multiple records within ours. Example :

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<type/>

</record>

</record>

</records>

I want to be able to parse these to I can have similar to table below

ID	Name	Type	Cost
1	Name1		10
2	Name2	CD	20

Please advise if this is possible?

Re: XML in a CLOB

Gysbert_Wassenaar — Thu, 11 Aug 2016 15:27:32 GMT

Perhaps the from_field load is an option. See some of the search results from this search: https://community.qlik.com/search.jspa?q=xml+from_field

Re: XML in a CLOB

william_denholm — Thu, 11 Aug 2016 15:48:27 GMT

Thank you. This works for one row in the DB, we have multiple DB rows each with multiple records in the XML/CLOB.

Any suggestions?

topic XML in a CLOB in QlikView

XML in a CLOB

Re: XML in a CLOB

Re: XML in a CLOB