Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bazzaonline
Creator
Creator

Load from txt not loading all records

Hello,

I need help, I'm trying to load data from a txt. file which contains about 600k rows, its only picking up 300k rows for some reason and I have no idea why??

Any help?

1 Solution

Accepted Solutions
Anonymous
Not applicable

Hello,

It did not happen to me but I saw some cases which happened to my friends here.

In that case, it might be a bug or something after a certain amount of rows. You may try things like:

1. loading and writing it to a qvd immediately. Then try to read from qvd and see if anything changes.

2. Try to read from csv.

3. You may ask to technical support if nothing works. If you are in older version, it may have been fixed or something.

BR

Serhan

View solution in original post

12 Replies
francoiscave
Partner - Creator III
Partner - Creator III

Hi Paul,

Qlikview display only the distinct rows after load .

Can you add the RowNo() function in your script to be certain that there are no "duplicate line".

François

arulsettu
Master III
Master III

post your text file

bazzaonline
Creator
Creator
Author

Morning and thank you, I have opened the txt file in excel and completed a duplication check and there are no dupplicates?

bazzaonline
Creator
Creator
Author

Sorry, thank you for the offer of support however the file contains information I'm not permitted to share..  Dpa issue

flipside
Partner - Specialist II
Partner - Specialist II

A common issue with text files is special (and non-visible) characters causing Qlikview to think it has reached the end of the file. If the load is always ending at the same record, then this is probably the reason. Does the last record end part-written? Try making a copy of the text file, delete the final record it is loading and see if it loads more records.

Fixing it is more problematic but try the above first and let us know if it changes things.

Anonymous
Not applicable

Hello,

It did not happen to me but I saw some cases which happened to my friends here.

In that case, it might be a bug or something after a certain amount of rows. You may try things like:

1. loading and writing it to a qvd immediately. Then try to read from qvd and see if anything changes.

2. Try to read from csv.

3. You may ask to technical support if nothing works. If you are in older version, it may have been fixed or something.

BR

Serhan

francoiscave
Partner - Creator III
Partner - Creator III

Hi Paul again,

There is a limit when you load .txt file ?

See the link below to have help:

http://community.qlik.com/message/44925#44925

François

bazzaonline
Creator
Creator
Author

Thank you, I think that might be the case.  Is there a quick way to work out which was the last record?

bazzaonline
Creator
Creator
Author

Ah, nice work.  Amending to csv seems to have sorted it!