Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When I load an *.tab file into QV, not all lines will be loaded (about half of the lines, file is about 120.000 lines long). When I import this file into Access and export it as .txt file and load this txt-file into QV ... all lines will be loaded. Has anyone the same problem and / or has anyone an answer to this problem?
Liesbeth
Set Quoting to standard (default is MSQ), this will disable records over multiple lines.
The problem is an unbalanced " sign, making qlikview interpreting the rest of the file after that as 1 record.
Hi, do you get the lines at the top, bottom or at randon?
Do you get the right values on the fields?
Can you share a piece of your file? and the script you are using to read it?
I think it maybe some script parameter ...
When I import the table file all looks well, all values seem to be at the right fields...
I attached the two files you asked for in my initial question.
Set Quoting to standard (default is MSQ), this will disable records over multiple lines.
The problem is an unbalanced " sign, making qlikview interpreting the rest of the file after that as 1 record.
Ah, yes, that helps. tnx