Problems Loading Data

[#1]

I am loading 3 years of data all from ascii files organized by invoice number. There are no errors in loading however I noticed some line items that are in the ascii files are not in Qlikview. Has anyone else experienced this or have a possible solution to this?.

When I do a search, there are no selections made that would limit the data output.

[Anonymous]

I don't think the problem is the size ... i have many project with ascii table and milions of record

[#3]

I was mistaken, what you said about removing the msq partially worked.

I am loading 4 files, a 2007,2008,2009 and a YTD record

The YTD records I believe are now fully being loaded, the scripts are all identicle however with the three previous years, only 65,533 lines are being fetched from each.

[Anonymous]

did u try with no qoutes?

FROM zzz.dat (ansi, txt, delimiter is '\t', no labels, no quotes);

[#5]

Just tried this, same results as before, only 65,533 lines fetched from three previous years, YTD fetched 146,554

[#6]

What alfasierra suggested worked in the end.

The three previous years files were corrupt, when I regenerated the files and removed the msq everthing loaded properly.

Thanks to everyone for there help!