Only a part of my file is imported

[#1]

Hello everyone,

I am facing a very weird issue...

I have a csv file with roughly 700 000 lines. I want to import it in Qlikview but I have found out that I could find some id that are in the files in QV..  So, I have added a counter in the script:

LOAD

1 as cpt,

var1,

....

FROM

D:\Myfile.csv...

And in a textbox, when I calculate sum(cpt), I get only 427 000  (approximately) whereas my file does contains at least 700 000 lines.

I really don't get why    This is the only file I import, there is nothing special in the script.

Any ideas ?

Thank you for your help

Have a good day

[alexandros17 · Accepted solution]

I think there should be a special character in a string or a EOF

let me know

[#3]

I have finally found another application where this file is used and, indeed, there is a noeof option :

txt, utf8, embedded labels, delimiter is ';', msq,no eof)

I didn"t know that option and that, per default, there is an eof.

Thank you for your help

[alexandros17]

Could you attach your file? I'll try to load ...

[Ralf-Narfeldt]

You could try adding the record number to possibly see if it stops somewhere.

LOAD

RecNo() as recno,

1 as cpt,

var1,

....

[#6]

I cannot, the data are confidential, but I was able to laod it by adding the 'noeof' option when I imported it.