topic Re: How To Load a xml column from sql server Into Qlikview as XML? in QlikView

How To Load a xml column from sql server Into Qlikview as XML?

Thu, 21 Feb 2013 18:53:43 GMT

Hi,

I have a sql server table in which one of the column value is XML.Now,I want to know how can i load this column directly into Qlikview back as XML?Is it possible to achieve it if so can somebody please help me?

Sample :

<ReasonCode>Register Open</ReasonCode>

<SystemCycleType>Register Open</SystemCycleType>

</ControlTransaction>

</Transaction>

</POSLog>

How can i load this as XML back into Qlikview?

Thanks.

Re: How To Load a xml column from sql server Into Qlikview as XML?

Anonymous — Thu, 21 Feb 2013 18:58:33 GMT

Hi,

Can you please attach test xml file.

Regards

Re: How To Load a xml column from sql server Into Qlikview as XML?

Thu, 21 Feb 2013 19:05:44 GMT

Hi Shaik,

Its not an XML File actually i dont know how we load this table but we do have a sql table which output is attached in the attachment and if you see that excel file in the second column MSG the value stored must be loaded into Qlikview as XML.

If you have any questions please let me know.

Thanks.

Re: How To Load a xml column from sql server Into Qlikview as XML?

Anonymous — Thu, 21 Feb 2013 20:37:35 GMT

Hi,

can you tel me how you need a end of result,can you share please.

Regards

Re: How To Load a xml column from sql server Into Qlikview as XML?

Thu, 21 Feb 2013 20:45:57 GMT

Hi Shaik,

I need some code to load this into Qlikview as an XML file.

Thanks.