topic .txt File not loading all data or rows in QlikView

.txt File not loading all data or rows

billuran — Mon, 01 Aug 2016 17:53:22 GMT

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?

Re: .txt File not loading all data or rows

m_woolf — Mon, 01 Aug 2016 18:19:57 GMT

Hard to say without seeing your data.

Have you tried Ignore EOF?

Re: .txt File not loading all data or rows

Oleg_Troyansky — Mon, 01 Aug 2016 18:51:44 GMT

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!

Re: .txt File not loading all data or rows

cmoralesmastel — Tue, 18 Jul 2017 11:39:55 GMT

Hi Oleg,

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

Coral.