topic Re: Hidden special character causing error in Section Access? in QlikView

Hidden special character causing error in Section Access?

Mon, 10 Dec 2012 22:17:20 GMT

I have a text file containing a Section Access table, that I pull into the load script as an include file. If the text file is generated from a machine source, such as SQL Server Management Studio or QlikView itself, I get an error message upon reloading, saying, 'Unable to find field <ACCESS>.'

If I open the problem text file and type its contents by hand into a new file in Notepad, the new file works. To the eye, the two files look identical. Does anyone have an idea what is wrong with my machine-generated file?

Thanks

Re: Hidden special character causing error in Section Access?

Gysbert_Wassenaar — Tue, 11 Dec 2012 20:01:37 GMT

Check the character set and labels settings. Perhaps they don't match those of your machine generated file.

(txt, utf8, embedded labels, delimiter is '\t', msq);

Re: Hidden special character causing error in Section Access?

Wed, 12 Dec 2012 21:32:10 GMT

Thanks, Gysbert, that was it! I had copied the load statement from a load of a file created by hand. The 'utf8' fixed it.