topic Re: 600000 Records in QlikView

600000 Records

Mon, 26 Jan 2026 18:19:17 GMT

Hello i have a txt file with 600000 records.

When i reload only 290.000 will be loaded.

I know that it is possible to load 600000 recrods.

But why stops it at 290.000 recs?

Thx in advance

Re: 600000 Records

jaimeaguilar — Thu, 13 Nov 2014 22:47:02 GMT

Hi,

probably is because there's a symbol that is interfering with your data. For example let's say that your file is a comma separated file and one of your records contains this string:

1, text, text, 'some text ' some more text'

In this example the single quotes are used for grouping text that contains spaces. However, there's another single quote that is actually part of the string. This will make your script to stop loading.

This is just an example, but in your case it could be something like this. Check if there's something strange in the record where your text file stops loading,

regards

Re: 600000 Records

Thu, 13 Nov 2014 23:17:00 GMT

Hi,

i Have deleted the lines and stops again at same line.

Re: 600000 Records

jduenyas — Thu, 13 Nov 2014 23:32:22 GMT

Try to load the same into Excel Delimited .CSV file format and verify that all loads as you expect.

If not, then something is wrong with your data.

After all is loaded, save again to a .CSV Comma delimited and try to load again to QlikView

Re: 600000 Records

rwunderlich — Fri, 14 Nov 2014 00:04:14 GMT

I think Jamie is on the right track. It's usually improperly escaped characters. In a CSV the double " is used to escape commas. " is also used as symbol for inches. Several times I have seen descriptions like

27" Monitor

cause a problem if the " is not escaped as well.

The data problem is always on the line where it stops, it may be a few lines behind. Try deleting 1000 lines prior to the failure. If that fixes it you can begin narrowing it down.

-Rob

Re: 600000 Records

Peter_Cammaert — Fri, 14 Nov 2014 08:55:15 GMT

Another idea that may be helpful: let QlikView assist you in finding the bad punctuation

Load lines with a line counter.
Create a table box will all fields from the text file and sort the content on descending line number.
Look for the earliest field value that is definitely wrong or out of order.

Peter

Re: 600000 Records

sujeetsingh — Fri, 14 Nov 2014 09:01:42 GMT

Peter has given you a way to analyse you data and find the ill sections.

Re: 600000 Records

Sokkorn — Fri, 14 Nov 2014 09:02:33 GMT

Hi Ama,

Maybe try this one and see those records

Regards,

Sokkorn