Loading in Attribute Centric XML in QlikView Load Script

[Glenn_Renwick]

Hi,

Has anyone got a nice way of working with XML that contain attributes? The QV load wizard does not seem to work well with it.

Here is a sample of XML.

<list>

     <ProfileDefinition>

          <string name="ID">1</string>

          <string name="name">My QlikView Application for XML</string>

     </ProfileDefinition>

</list>

After loading, I would like to see

Table Name: ProfileDefinition

ID	Name
1	My QlikView Application for XML

Thanks

[Glenn_Renwick · Accepted solution]

Hi,

I got a solution.

Basically loading 1 attribute value at a time using Where and then joining the attributes based on a RowNo() key.

ProfileDefinition:

LOAD

    RowNo() as AutoKey,

    string%Table as ID

WHERE name = 'ID';

LOAD string%Table, name

FROM C:\Test.xml (XmlSimple, Table is [list/ProfileDefinition/string]);

Join

LOAD

    RowNo() as AutoKey,

    string%Table as Name

WHERE name = 'name';

LOAD string%Table, name

FROM C:\Test.xml (XmlSimple, Table is [list/ProfileDefinition/string]);

Drop field AutoKey;