topic load .tab file in QlikView

load .tab file

Tue, 31 May 2011 10:02:50 GMT

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

load .tab file

erichshiino — Tue, 31 May 2011 13:47:35 GMT

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 ...

load .tab file

Tue, 31 May 2011 13:58:35 GMT

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.

load .tab file

kji — Tue, 31 May 2011 14:08:59 GMT

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.

load .tab file

Tue, 31 May 2011 14:15:22 GMT

Ah, yes, that helps. tnx