topic Re:Loading data from xml file. in QlikView

Re:Loading data from xml file.

senpradip007 — Mon, 17 Sep 2012 11:44:21 GMT

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:

<COMPANY>Company Name ABC</COMPANY>

<BRANCH>Branch BCA</BRANCH>

<LINE_NO>1</LINE_NO>

<LEDGER>XYZ AGENCY</LEDGER>

</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

Re:Loading data from xml file.

jonathandienst — Mon, 17 Sep 2012 11:49:24 GMT

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

Re:Loading data from xml file.

senpradip007 — Tue, 18 Sep 2012 07:16:10 GMT

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

Re:Loading data from xml file.

jonathandienst — Tue, 18 Sep 2012 11:38:31 GMT

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

Re:Loading data from xml file.

senpradip007 — Tue, 18 Sep 2012 12:00:09 GMT

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