Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview 11 for developers - Incorrect data loading on page 73

I am on page 73 and I am loading data according to the steps in the book. The book loads lesser rows than me. Why ?

My load results -

Main Data << Flight Data (qvd optimized) 1,256,075 lines fetched

Carrier Groups << Carrier Groups (qvd optimized) 8 lines fetched

Airlines << Airlines (qvd optimized) 1,548 lines fetched

Carrier Operating Region << Carrier Operating Region (qvd optimized) 6 lines fetched

Flight Types << Flight Types (qvd optimized) 4 lines fetched

Aircraft Groups << Aircraft Groups (qvd optimized) 10 lines fetched

Aircraft Types << Aircraft Types (qvd optimized) 379 lines fetched

Distance Groups << Distance Groups (qvd optimized) 25 lines fetched

Connecting to Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\QlikView Development\Airline Operations\Data Files\MDBs\Dimension Tables.mdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False

Connected

Origin Airports 6,209 lines fetched

Destination Airports 6,209 lines fetched

Book load results -

Capture.JPG.jpg

1 Solution

Accepted Solutions
arsal_90
Creator III
Creator III

Hi John

Your data is right if u see the access file in which Destination and Origin Airports have 6209 Rows. Might be it's error in the book when they are testing that app then they have only 2104 and 2169 rows.

View solution in original post

2 Replies
arsal_90
Creator III
Creator III

Hi John

Your data is right if u see the access file in which Destination and Origin Airports have 6209 Rows. Might be it's error in the book when they are testing that app then they have only 2104 and 2169 rows.

Not applicable
Author

Thanks. Yes, I checked it. My output is correct. I don't know why they have these differences.