Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Issue with loading from .ttx

Hi I have a tab separated txt file (extension .ttx), when loading into QV it recognises the fields and the headers but only loads 21,000 rows of data instead of 68,000 - any ideas why this would be happening?

Re-saving the file with a .txt extension stops the issue but I can't automate the conversion...

Thanks,

CJ

2 Replies
Gysbert_Wassenaar
Not applicable

Re: Issue with loading from .ttx

Did you only rename the file or first open it and then save it with another name? I think there's likely a special character  that it chokes on. Opening the file and resaving it might convert that character so it doesn't trip up the load anymore. This can happen for example when you get a UTF-8 encoded file and try to read it as ascii. You may need to change the charachter set setting:

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

(txt, utf8, no labels, delimiter is ';', msq);


talk is cheap, supply exceeds demand
Not applicable

Re: Issue with loading from .ttx

Thanks for this, the issue was in regards to quoting style, changing from MSQ to standard fixed this.