0 Replies Latest reply: Dec 9, 2011 10:44 PM by Santosh Rao RSS

    QlikView 10 SR 4 - FromField Issue when Loading a DB Field with XML Content

      I have a requirement, where i need to load a number of rows from a database table, where a column contains XML data.

       

      I tried using From_Field function, and saw few people having tried this in the past, possibly without success. Later i found a recently release QV 10 Service Pack 4 fixes the issue. Possibly not completely. 

      (Ref

      35950 - Unknown error in MSXML when parsing XML data using LOAD FROM_FIELD

       

       

       

       

      I have attached a sample:

      a) SingleRowLoad.qvw This one loads a single row from a table, which loads successfully.

      b) MultiRowLoad.qvw This one tries loading more than one single row from a table, which fails

      c) MultiRowLoadWorkAround.qvw I have just attached a workaround, where i am loading all rows from the table and subsequently loading 1 field at a time to a temporary table and loading the fields from XML subsequently.

       

      Could anyone advise if there is a way to solve this as i may be missing something. Your help greatly appreciated.

       

      Regards,

      Santosh

       

      http://community.qlik.com/blogs/supportupdates/2011/12/02/qlikview-version-10-service-release-4-now-available)