Discussion board where members can get started with QlikView.
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>
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.
This code generated by the XML wizard
FROM (XmlSimple, Table is [ENVELOPE/VOUCHER]);
// End of [Test.xml] LOAD statements
produces one table, with the data in fields.
Hope that helps
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.
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.
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.