Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

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. 


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.




Community Browser