Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Just running through some examples laid out in Qlikview 11 for Developers and am getting an odd result while trying to work through the crosstable example in Chapter 9. I have done cross tables many times before and it has worked like a charm but this time, I keep getting orphan tables that equate to the fields that are being uncrosstabled (Months) being produced.
I am fairly certain that the script below is correct because the table that it creates contains all the right info. The month field is created properly. But there are these orphan tables that just won't go away.
CrossTable:
CrossTable(Month, No_Employees, 9)
LOAD
%Key,
Year,
[Airline ID],
[Unique Carrier Code],
[Unique Carrier],
[Carrier Code],
[Carrier Name],
[Carrier Group ID (Old)],
[Carrier Group ID],
[01],
[02],
[03],
[04],
[05],
[06],
[07],
[08],
[09],
[10],
[11],
[12]
FROM [Employment Statistics - CrossTable.qvd] (qvd);
See Tableview below.
Is this a known bug?
Is there a list of known bugs by version that one can check for stuff like this?
My version is 11.20.12904.0 SR12 64 Bit.
Thanks in advance for your help.
Cheers
KH
I tried it using "Inline Load" and getting results as expected.
I am using 11.20 SR5, not sure about SR12
Can you try Inline Load once in SR12, so that can check the problem.
I have never seen this. Is that the complete load script? How many rows and what data is in the orphan tables?
Use 10 instead of 9.
See here: Explain the orphan table bursting
- Marcus
Hi Rajesh,
I tried 10 instead of 9 but got the same resulting orphan tables.
Both of the work arounds in Marcus' doc worked though.
Hi Marcus,
Thanks for the doc. Both work arounds worked perfectly!
Hi Jonathan - yes this is the complete script.
The work arounds that Marcus sent eliminated the problem.
However, I ran the script again to check on the rows and data in each orphan that you asked about.
Each orphan has the data related to the month it cross tabbed.
I got an error message that may be part of the cause.
I am using Personal Edition with sample apps and QVDs that come with Qlikview for Developers.
By the looks of this message, I appear to have corrupted the embedded license in the sample files.
Thanks for your help!
Hi Pradeep,
The doc from Marcus provided two workarounds that both work.
I would test with SR12 but have my system working fine and don't want to risk upgrading just yet.
Cheers,
Kevin
Use where1=1;
in he load statement