Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikhans
Creator
Creator

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
Creator
Creator
Author

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

View solution in original post

7 Replies
PrashantSangle

Hi,

can you post sample file.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Anonymous
Not applicable

Hi Hans,

Set ignore EOF on when reload txt file.

Regards!

Not applicable

Try:

LOAD *

From \\file\sample.txt

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

Not applicable

beat me to it. LOL

qlikhans
Creator
Creator
Author

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

qlikhans
Creator
Creator
Author

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
Creator
Creator
Author

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