Discussion Board for collaboration on QlikView Scripting.
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?
Go to Solution.
Hi all, I think I found my answer in
QV loads only 20% of data from a txt
asnwered by Rob Wunderlich
let's see what problems that causes
can you post sample file.
Set ignore EOF on when reload txt file.
(txt, codepage is 1252, embedded labels, delimiter is '!', msq, no eof);
beat me to it. LOL
no, sorry. it is live data that I am not allowed to distribute. probably when setting up sample, issue will not occur
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