Problem loading complete data from txt File to QVD/QVW

[gyan_srivastava]

Hi,

I am facing very strange problem .I am trying to load data from txt file to Qlikview QVD file /Table .

Txt file is contaning 1 Lakh 64 thousand records(164400) .

But while loading in QVD the records loading in QVD are only 132864 .Rest records are not getting loaded .

But when i am loading records in SQL server table ,All 164400 records got loaded and then Further I tried loading from Sql Server to QVD all 164400 records loaded to QVD.

Is there any Problem or Bug in Qlikview to Load complete data from txt to QVD .

If any one faces this issue or can suggest some workaround then please reply ...I am stuck by this.

[amars]

Hi Gyan,

I am not quite sure about this but Can u check if there are duplicate rows in ur data, if there are duplicate rows in ur text files they are suppressed, I hope. Try generating some rowNo in ur data so the rows will be unique & will not be suppressed.

Thanks

[gyan_srivastava]

I have Employee ID as a unique field available in Data . And data is completely getting loaded in Sql Server Table .

And Also complete data is getting loaded to QVD if I am loading data from Sql Server table to QVD. I am having problem only with text file to QVD for same data .

Please suggest.

[johnw]

Not sure if this is the problem, but I believe QlikView stops if it hits what it interprets as and end of file character. You could see what row it stops on, and look for strange characters nearby.

[Anonymous · Accepted solution]

It might be related to quoting and quotes missing somewhere along the rows.

For example, I'm pretty sure something like this would mess up the reload (check the quoting on value3):

"value1", "value2", "value3, "value4"
"value5", "value6", "value7", "value8"

Another thing to try would be to use standard quoting instead of MSQ when loading the text file (either in the table load wizard, or by removing the msq from the From part of the load statement).

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

[gyan_srivastava]

Thanks a lot removing msq from load statement has done the Job .And I Also got when MSQ creates problem with some of the data.

[gyan_srivastava]

Help for another members who will face this problem,

This problem is usually caused by MSQ, modern style quoting, in the load statement. When using MSQ not all rows and columns will be loaded. Here's an explanation to why this is happening:

MSQ, modern style quoting is another way of loading the structured data from different types of sources. It handles quotes a little differently and in this case there are certain inconsistencies in the data causing fewer rows to be loaded when using MSQ.

An example row is this one:

"A";"253";"0001-01-01";"21";"82";"";"33";"76";" "MAIERHOF";"";"";"";"";"SCALZOTTO";"2006-05-04"

Please take a look at how MAIERHOF is quoted:

;" "MAIERHOF";

Resolution :

suggestion is that you remove the MSQ from the load statement and check if this solves the issue.

[siddharth_kulka]

I faced the same problem and your suggestion helped. So thanks

Would like to know the difference between MSG, Standard and No Quotes. Not sure why its not in the manual.