Parse XML in database

Fri, 25 Apr 2014 09:51:07 GMT

Hi there,

I'm currently faced with a situation where I have XML data stored as a string in a database. An example of what this data looks like:

<?xml version="1.0" encoding="utf-16"?> <Quote xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <IDType>ID_SA</IDType> <IDNumber /> <GenderCde>Male</GenderCde> <MaritalCde>Married</MaritalCde> <DateOfBirth>1989-02-02T00:00:00</DateOfBirth> <Suburb>GEORGE</Suburb> </Quote>

Is there any straightforward way to parse this in the load script such that, for the above, I'd end up with:

IDType	GenderCde	MaritalCde	DateOfBirth	Suburb
ID_SA	Male	Married	1989-02-02T00:00:00	George

Any help on this would be greatly appreciated.

Cheers

Re: Parse XML in database

Gysbert_Wassenaar — Fri, 25 Apr 2014 17:04:08 GMT

That seems to be very tricky. Perhaps these discussions can help you further:

QlikView 10 SR 4 - FromField Issue when Loading a DB Field with XML Content
xml data handling with from_field

topic Re: Parse XML in database in QlikView

Parse XML in database

Re: Parse XML in database