3 Replies Latest reply: Oct 11, 2014 9:54 AM by Marco Wedel RSS

    XML Load Question: repeating nodes

      Hi all,

      Any thoughts on how to load an XML file of the structure:

       

      <?xml version='1.0' encoding='utf-8'?>

      <table title='Project Entities'>

        <columns>

               <column name='_humanised_name' title='Name' description='The name of the entity' width=''/>

               <column name='ENTITY_ID' title='Ref' description='Internal entity reference' width=''/>

        </columns>

        <rows>

             <row>

                  <cell value='Customers'/>

                  <cell value='1'/>

             </row>

             <row>

                  <cell value='Orders'/>

                  <cell value='2'/>

             </row>

        </rows>

      </table>

       

      So that the table is represented in Qlikview as:

       

       

      Entity, ID

      Customers,1

      Orders,2

       

      When using the generated XmlSimple statement, synthetic keys and an incorrect data model are generated.

       

      Thoughts!?

      Many thanks,

      Dan