Discussion Board for collaboration on QlikView Scripting.
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.
<string name="name">My QlikView Application for XML</string>
After loading, I would like to see
Table Name: ProfileDefinition
I got a solution.
Basically loading 1 attribute value at a time using Where and then joining the attributes based on a RowNo() key.
RowNo() as AutoKey,
string%Table as ID
WHERE name = 'ID';
LOAD string%Table, name
FROM C:\Test.xml (XmlSimple, Table is [list/ProfileDefinition/string]);
string%Table as Name
WHERE name = 'name';
Drop field AutoKey;
View solution in original post