Re:Loading data from xml file.

[senpradip007]

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

[jonathandienst]

Pradip

This code generated by the XML wizard

VOUCHER:

LOAD COMPANY,

    BRANCH,

    DATE,

    TYPE,

    LINE_NO,

    CODE,

    LEDGER,

    AMOUNT

FROM (XmlSimple, Table is [ENVELOPE/VOUCHER]);

// End of [Test.xml] LOAD statements

produces one table, with the data in fields.

Hope that helps

Jonathan

[senpradip007]

Hi Jonathan,

Thanx for the suggestion.

Say these fields contain 2 values and TYPE field contains one NULL data. Then final table should contain 2 rows of data.

Now the problem is qlikview load 1 row, it eleminates Null data of TYPE field.

Can you give more suggestion.

Regaeds

Pradip

[jonathandienst]

Pradip

I suggest that you post a sample of the XML file that demonstrates that behaviour, which does not seem like normal QV behaviour. If I can replicate your problem, then we can look for a solution.

Regards

Jonathan

[senpradip007]

Hi Janathan

I'av posted the sample xml file. It contains 2 rows of data. When I load it data of 1st row is loaded but 2nd row is not loaded. Please help me to get rid of this problem.

Regards

Pradip