Incomplete CSV Loading

[agni_gold]

Hi All ,

I am trying to load CSV having 1 million records , but it stopes at 7 lacs , And my CSV is delimited by ~ .

I have tried many way to handle this issue by Qoutes none and ingnore end of file  like that options , but when i am using it it is loading more than 1 million records.

[Peter_Cammaert]

Can you post that part of the CSV where QlikView stops loading? Let's say 10 lines before and 10 lines after...

[#3]

Can you send a sample of the CSV file?

[agni_gold]

Sorry csv i cant because it is in client area . But it is not giving any error while loading execution will sucessfully finished at 7 lac records.

Is there any way to find which row creating error?

[agni_gold]

stalwar1‌

gwassenaar‌

Any suggestion on this

[muthukumar77]

Hi,

Can you send me error in screenshot?

[#7]

Use the First function to see where is breaking.

Try Half million if it works load more if not start to reduce until you have a clue where it is.

You might have a data error in the data and you need to make some data cleaning.

example: First 10 Load * from abc.csv;

[santiago_respane]

Hi, always that i had this kind of problems is was because of a bad formed csv,

Have you tried adding the "no eof" specifier in your load?

LOAD * from myfile.csv (txt, utf8, embedded labels, delimiter is '~', no eof);

Hope this helps.

Kind regards,

[agni_gold]

It is loading more that exact rows....

Total Records in CSV : 1 Million

But it is loading 1.8 million

[Peter_Cammaert]

Your Op has a title that says "Incomplete CSV Loading", and now you say that almost double the amount of rows are loaded? That could be caused by Newline-characters (ASCII value 10) in text fields in your csv file. They will be treated as line separators, turning every row into two rows.

BTW what does "lacs" mean?

Peter