topic Loading in Attribute Centric XML in QlikView Load Script in QlikView

Loading in Attribute Centric XML in QlikView Load Script

Glenn_Renwick — Thu, 19 Apr 2012 08:22:02 GMT

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>

<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 — Fri, 20 Apr 2012 15:11:41 GMT

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;