XML in a CLOB

[william_denholm]

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"?>

<records>

     <record>

          <id>1</id>

          <name>Name1</name>

          <type/>

          <cost>10</cost>

     </record>

     <record>

          <id>2</id>

          <name>Name2</name>

          <type>CD</type>

          <cost>20</cost>

     </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?

[Gysbert_Wassenaar · Accepted solution]

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

[william_denholm]

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?