Load from txt not loading all records

[bazzaonline]

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?

[francoiscave]

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]

post your text file

[bazzaonline]

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

[bazzaonline]

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

[flipside]

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 · Accepted solution]

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]

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]

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

[bazzaonline]

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