Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Hi! uploading a CSV file of about 39000 lines, only 60 actually load !, what could be the problem?

Hi! uploading a CSV file of about 39000 lines, only 60 actually load !, what could be the problem?

9 Replies
oknotsen
Honored Contributor III

Re: Hi! uploading a CSV file of about 39000 lines, only 60 actually load !, what could be the problem?

Could you show us the load script you are using and maybe a few lines of that CSV?

Are you using the (limited load function of the) debugger perhaps?

May you live in interesting times!
tajmohamed30
Contributor III

Re: Hi! uploading a CSV file of about 39000 lines, only 60 actually load !, what could be the problem?

Hi if you loading only that csv file and not using any other variables and still only 60 lines getting loaded you can try re-install/update the app by checking whether your system os and qlikview version is same 32bit/64bit

martinpohl
Valued Contributor II

Re: Hi! uploading a CSV file of about 39000 lines, only 60 actually load !, what could be the problem?

Check if that there is no endoffile symbol in your datas.

You can see the loaded datas in your csv, so what is the next letter in the file?

tomasz_tru
Valued Contributor

Re: Hi! uploading a CSV file of about 39000 lines, only 60 actually load !, what could be the problem?

Maybe try to add 'no eof', like in the below example:

LOAD *

FROM [lib://xxxxxxxx.csv]

(txt, codepage is 1250, embedded labels, delimiter is '\t', no quotes, no eof)

Highlighted
chooco_co
Valued Contributor

Re: Hi! uploading a CSV file of about 39000 lines, only 60 actually load !, what could be the problem?

Hi Tomasz,

Actually i have the same problem like Martin, I have txt file total rows 131965

csv row.png

Here's my load script

[Invoice]:

LOAD *

FROM [lib://**/Invoiceheader.txt]

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

and below data that loaded into Qlik Sense

row extraact.png

Any idea?

Thanks

Marco

tomasz_tru
Valued Contributor

Re: Hi! uploading a CSV file of about 39000 lines, only 60 actually load !, what could be the problem?

Have you checked rows around 16857 in an input file?

tajmohamed30
Contributor III

Re: Hi! uploading a CSV file of about 39000 lines, only 60 actually load !, what could be the problem?

have you followed gayan's information for row count mismatch from Record Count Mismatch

It could be an issue with the source excel file. I had the same issue recently when trying to upload the data. After trial and error I managed to tally the records between the excel file and the table.

Open your excel file, go to the last record in the sheet, select all the rows below the last record (technically all empty rows) and delete it. Re-run the script and see if the count matches.

This worked for me but honestly I am not sure why it causes such a problem in the first place.

Hope this helps.

jyothish8807
Honored Contributor II

Re: Hi! uploading a CSV file of about 39000 lines, only 60 actually load !, what could be the problem?

Hi Martin,

Try making the below change in you from statement:

normal load statement:

Load

A

FROM

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

Corrected one:

Load

A

FROM

(txt, codepage is 1252, no labels, delimiter is ',', no quotes);

****** I just changes the "msq" to "no quotes".

Br,

KC

Best Regards,
KC
tomasz_tru
Valued Contributor

Re: Hi! uploading a CSV file of about 39000 lines, only 60 actually load !, what could be the problem?

Have you found what was wrong?

Tomasz