Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

qlikhans
Contributor

txt file versus xlsx file

In my document I load txt files. the last lines of my transaction data (txt) do not show.

When I convert txt to xlsx and upload the xlsx file, all lines show

file only has 336 lines so it is not very large

Similar behaviour I have seen before. I want to use the txt files and not the excel files. Does anyone have an idea why this happens and how to avoid it?

brgrds

Hans

1 Solution

Accepted Solutions
qlikhans
Contributor

Re: txt file versus xlsx file

Hi all, I think I found my answer in

QV loads only 20% of data from a txt

asnwered by Rob Wunderlich

remove msq

let's see what problems that causes

7 Replies

Re: txt file versus xlsx file

Hi,

can you post sample file.

Regards

Regards,
Prashant Sangle
manucamon
Valued Contributor III

Re: txt file versus xlsx file

Hi Hans,

Set ignore EOF on when reload txt file.

Regards!

Not applicable

Re: txt file versus xlsx file

Try:

LOAD *

From \\file\sample.txt

(txt, codepage is 1252, embedded labels, delimiter is '!', msq, no eof);

Not applicable

Re: txt file versus xlsx file

beat me to it. LOL

qlikhans
Contributor

Re: txt file versus xlsx file

no, sorry. it is live data that I am not allowed to distribute. probably when setting up sample, issue will not occur

qlikhans
Contributor

Re: txt file versus xlsx file

hi Manuel, had done that to transaction file before posting my question. It did not solve the issue. have done that now to all txt files, also not the hoped for result

krgrds

qlikhans
Contributor

Re: txt file versus xlsx file

Hi all, I think I found my answer in

QV loads only 20% of data from a txt

asnwered by Rob Wunderlich

remove msq

let's see what problems that causes

Community Browser