Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am trying to load two different files in qlikview client
File 1 : Size=9040 KB RecordCount = 186387
File 2 : Size=46601KB RecordCount = 93194
File 1 is getting loaded properly(having more records) whereas the File 2 is loading just 91000+(approx) records.
Is there any limitation of the size of the file, which can be loaded in the client.
No, there is no limitation. If your file contains an EOF character, this could happen. When you create your Load statement you should perhaps check "Ignore EOF".
HIC
No, there is no limitation. If your file contains an EOF character, this could happen. When you create your Load statement you should perhaps check "Ignore EOF".
HIC
The size is rather small and no there aren't limitations. Perhaps you have duplicated rows which you excluded per distinct or any other where-condition.
- Marcus
This is not a Huge size with qv. Follow this discussion: data load problem
No in QV as such no limit if you having problem then the way to check the system RAM capacity and try to create the QVD of the tables like or may be synthetic tables created in the memory then it takes time or may be any joins.
File1:
Load * From Location;
Store File1 into File1.qvd(qvd);
Drop Table File1;
File2:
Load * From Location;
Store File2 into File2.qvd(qvd);
Drop Table File2;
Try to drop the tables after created as the QVD and then reload data from the QVD to the application.
Hi Henric,
I have tried to load file with "Ignore EOF" checked.
It is still doing the same number of loads as earlier.
Is there any other way for that.
Thanks in advance ..
Sorry for wrong reply,
at first load, it did not work,
now it is working fine
Thanks for help!!
You need to figure out what goes wrong, and where. Here are some debug ideas:
HIC