Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
can you post sample file.
Regards
Hi Hans,
Set ignore EOF on when reload txt file.
Regards!
Try:
LOAD *
From \\file\sample.txt
(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
krgrds
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