Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Parse XML in database

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:

IDTypeGenderCdeMaritalCdeDateOfBirthSuburb
ID_SAMaleMarried1989-02-02T00:00:00George

Any help on this would be greatly appreciated.

Cheers

1 Reply

Re: Parse XML in database

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


talk is cheap, supply exceeds demand
Community Browser