topic .txt file not uploading fully in QlikView

.txt file not uploading fully

london1980 — Fri, 20 Nov 2015 17:44:39 GMT

Hi All,

I have a .txt file that I'm pulling the data from. It has 130k lines in it, QV is only importing 90k of these lines. I tried some other .txt files as well, it's always doing the same thing, not importing the entire file.

When I open my .txt in Excel and save it as .xlsx file and then import it, then it works but I have to do it every day. Anyone's got an idea how to fix this?

Here is my import script:

LOAD IMPORT_DATE,

WEEK_NO,

SKU,

QTY

FROM

[\\ant\daily_extracts\Demand.txt]

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

Re: .txt file not uploading fully

Gysbert_Wassenaar — Fri, 20 Nov 2015 18:01:16 GMT

There might be a character in that file somewhere that's not in the codepage 1252 set. You could try UTF-8.

Re: .txt file not uploading fully

sinanozdemir — Fri, 20 Nov 2015 18:02:45 GMT

When you open it in Excel, are you still using '\t' as the delimiter or something different? I have never had this problem, but I am just curious now.

Re: .txt file not uploading fully

nagarjuna_kotha — Fri, 20 Nov 2015 18:22:11 GMT

Hi Mahm,

i'm Not sure but I give you suggestion to you, if you do that you might get it.

1) Open your text file Crtl +A and Crtl + C.

2) Open one new Excel file and CRTL + V and Save.

load the excel in your script. I tried this last time. if it possible try this.

Regards,

Nagarjuna

Re: .txt file not uploading fully

marcus_sommer — Sat, 21 Nov 2015 15:02:35 GMT

Try it without msq and an eof-handling like:

(txt, codepage is 1252, embedded labels, no eof, delimiter is '\t', msq)

If this not worked you need to find the records which are not loaded respectively the record on which the loading stopped - recno() and rowno() are very helpful here: Counters in the Load - and then to search which chars could be cause the problem (you will probably need a hex-editor for this).

- Marcus