Script: using "xmlSax" for loading xml files

Thu, 26 Dec 2013 17:14:42 GMT

I am trying to use xmlSax format in a script.

With "xmlSimple" the syntax i use works, but when I replace xmlSimple with xmlSax the script fails.

lnkValue:

LOAD value,

label,

seq,

dflt,

%Key_admin_5D61A36D8297C46F // Key to parent table: codif/admin

FROM C:\data\admin.20130925\10_ref_spec_NCG.001.xml (XmlSimple, Table is [codif/admin/ref_spec_NCG/lnkValue]);

admin:

LOAD xmlns:xsi,

xmlns,

[ref_spec_NCG/spec_NCG] as spec_NCG,

[ref_spec_NCG/label],

%Key_codif_4EADC4DCBD4A1192, // Key to parent table: codif

%Key_admin_5D61A36D8297C46F // Key for this table: codif/admin

FROM C:\data\admin.20130925\10_ref_spec_NCG.001.xml (XmlSimple, Table is [codif/admin/ref_spec_NCG]);

Source xml is :

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

<codif xmlns="http://codif.darty.fr" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://codif.darty.fr http://codif.darty.fr/schemas/codif.xsd"

source="PCM" reference="init" issued="2013-09-25T14:00:00.0Z">

<admin xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xmlns="http://codif.darty.fr/admin">

<ref_spec_NCG>

<spec_NCG>CHAR</spec_NCG>

<label>CHARNIERE</label>

<label>CHARNIERE INCHANGEE</label>

</lnkValue>

<label>CHARNIERE A DROITE</label>

</lnkValue>

<label>CHARNIERE A GAUCHE</label>

</lnkValue>

</ref_spec_NCG>

</admin>

<admin xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xmlns="http://codif.darty.fr/admin">

<ref_spec_NCG>

<spec_NCG>CLE</spec_NCG>

<label>SERRURE OPTIONNELLE</label>

<label>SANS SERRURE</label>

</lnkValue>

<label>AVEC SERRURE</label>

</lnkValue>

</ref_spec_NCG>

</admin>

topic Script: using "xmlSax" for loading xml files in QlikView

Script: using "xmlSax" for loading xml files