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

[#1]

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 :

<POSLog>

  <Transaction CancelFlag="false" TrainingModeFlag="false" OfflineFlag="false" AppVersion="4.5.1.5 - 6.19.1 - 0.0" TransactionType="WORKSTATION_OPEN">

    <RetailStoreID>3975</RetailStoreID>

    <WorkstationID>1</WorkstationID>

    <TillID>39750001000047</TillID>

    <SequenceNumber>1245</SequenceNumber>

    <BusinessDayDate>2012-11-30</BusinessDayDate>

    <BeginDateTime>2012-11-30T11:56:23.431</BeginDateTime>

    <EndDateTime>2012-11-30T11:56:23.431</EndDateTime>

    <OperatorID>1</OperatorID>

    <CurrencyCode>USD</CurrencyCode>

    <ControlTransaction>

      <ReasonCode>Register Open</ReasonCode>

      <SystemCycleType>Register Open</SystemCycleType>

    </ControlTransaction>

  </Transaction>

</POSLog>

How can i load this as XML back into Qlikview?

Thanks.

[Anonymous]

Hi,

Can you please attach test xml file.

Regards

[#3]

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.

[Anonymous]

Hi,

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

Regards

[#5]

Hi Shaik,

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

Thanks.