I'm trying to load a .txt file into Qlik Sense and I'm having a problem capturing all 32K rows in that file. I'm making a very simple load script from a single file and the end result in Qlik just shows me around 19k rows. I downloaded the original file, from the AWS S3 bucket, and compared it to the cvs download of a table created in Qlik from the same file. I noticed that after a specific number of lines it looks like the loading script is ignoring the end of a line and jumping between lines. I'm adding the load script here as an example.
LOAD [@1] as description, [@2] as root, [@3] as main_day, [@4] as location, [@5] as main_year,
left(FileName(), len(FileName())-4) as dataset
FROM [lib://xxx_S3/output/] (txt, codepage is 28591, no labels, delimiter is ';', msq);
I just don't know if it's a problem with the txt file format or a problem with the loading script.
I've created a data sample that shows the issues, and I've tried replying to your message several times over the past week. Unfortunately, I got an error message from the community, it looks like the inbox was full.
I didn't know we have the option to upload from here until now.
Sorry for my delay in sharing the sample data in QVD format with you.
Did you try csv format, I see similar error mentioned in the below post, see if this helps as it appears debugging would need running load script, for me your connection won't work.
