Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

load .tab file

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

1 Solution

Accepted Solutions
Employee
Employee

load .tab file

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.

4 Replies
erich_shiino
Honored Contributor

load .tab file

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

Not applicable

load .tab file

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.

Employee
Employee

load .tab file

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.

Not applicable

load .tab file

Ah, yes, that helps. tnx

Community Browser