Why am I unable to load a txt file completely? - Qlik Community

nikita42 · ‎2016-02-03

I have a txt file (tab delimited) with over 94,000 rows. When I extract this to Excel, the count drops to 93,000 so I'm trying to upload the txt directly onto QlikView. For some reason, QlikViw is only loading a little over 20000 rows from the txt file. I've tried using different delimiters, only loading 1 or 2 fields, etc but I'm still facing the same issue.

Any ideas?

settu_periasamy · ‎2016-02-04

Can you post your script and the sample text file?

jonathandienst · ‎2016-02-04

Its hard to say for sure. I have text files with several million lines that load without a problem. Perhaps there is some problem with the file - such as embedded quotes. Experiment with the quoting options, such as

(txt, .... no quotes)

(txt, ..... msq)

(txt,

The other problem could be the code page. Is the data that actually loads correct?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

jonathandienst · ‎2016-02-04

You could also open this in a good text editor (Notepad++, EltraEdit, etc) to look for issues. Start at the last line that loaded successfully.

Also create a backup, and then in a text editor delete the first 1000 lines and try again. Does it load the same number of lines or 1000 less lines? This would help to discover the issue.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

avinashelite · ‎2016-02-04

please provide the sample file ..will check and let you know

Report Inappropriate Content · ‎2016-02-04

This is a good start, I had the same issue with a relatively small file and it was because msq was selected, try with no quotes

ramasaisaksoft · ‎2016-02-04

Hi Nikita Naresh,

pls share that same excel file which you are facing issue with some data ,so that we will also check and update to you ASAP.

sathishkumar_go · ‎2016-02-04

Hi,

You have to provide the sample file then only we can able to identify the issue.

-Sathish

marcus_sommer · ‎2016-02-04

In addition to the suggestions from Jonathan try also:

(txt, .... no eof)

- Marcus

Report Inappropriate Content · ‎2016-02-04

Hi,

One of the problems with text files is that they could be currupt.

Try breaking the file down into chunks of 10K records and see how it goes.

Also if you know VBS create a script that will read line by line the data and on the line that does not have the same number of delimmiters will let you know.

The source system may have provided data with line breaks in the field that ususally messes up the txt file with delimmiters.

hope this helps.

Anurag