Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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;