4 Replies Latest reply: Sep 18, 2012 8:00 AM by Pradip Sen RSS

    Re:Loading data from xml file.

    Pradip Sen

      Hi all,

       

      I'm new in qlikview. I want to load data from xml file but could not get the desired result.

       

      The following codes are xml code:

      <ENVELOPE>

            <VOUCHER>

                  <COMPANY>Company Name ABC</COMPANY>

                  <BRANCH>Branch BCA</BRANCH>

                  <DATE>1-1-2012</DATE>

                  <TYPE>BCA LEDG</TYPE>

                  <LINE_NO>1</LINE_NO>

                  <CODE>GH2020</CODE>

                  <LEDGER>XYZ AGENCY</LEDGER>

                  <AMOUNT>10</AMOUNT>

                  <NARRATION />

            </VOUCHER>

      </ENVELOPE>

       

      When I load the data from xml I get 8 tables named Company, Branch, Date, Type, Line_No, Code, Ledger, Amount.

      But my desired result is to get Company, Branch, Date, Type, Line_No, Code, Ledger, Amount as the attribute.

       

      Can anyone help me to get rid of this problem?

       

      Thanx in advanced.

      Pradip