.txt File not loading all data or rows

[billuran]

Hello All, I have a .txt file (No access to DB), and I am missing data.

I was missing a lot when i  had MSQ set

(txt, codepage is 1252, embedded labels, delimiter is '|', MSQ);

And i have most when i have no quotes.

(txt, codepage is 1252, embedded labels, delimiter is '|', no quotes);

Why am I still missing data? Is there a fix to this?

[m_woolf]

Hard to say without seeing your data.

Have you tried Ignore EOF?

[Oleg_Troyansky]

I had a similar problem once... It has to do with quoting, and apparently the MSQ setting causes the data to be cut in certain cases. In my case, switching to "no quotes" had solved the problem.

You should find the problematic character and try to eliminate it from your data load. I'm not aware of any "bullet-proof" solutions for this problem.

cheers,

Oleg Troyansky

Upgrade your Qlik skills at the Masters Summit for Qlik - coming soon to Austin, Texas and Johannesburg, South Africa!

[cmoralesmastel]

Hi Oleg,

Switching to "no quotes" has fixed my problem, thanks!

Coral.