1 Reply Latest reply: Apr 20, 2012 11:11 AM by Glenn Renwick RSS

    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

       

      IDName
      1My QlikView Application for XML


       

      Thanks

        • Loading in Attribute Centric XML in QlikView Load Script
          Glenn Renwick

          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;