Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);
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);
Thanks, Gysbert, that was it! I had copied the load statement from a load of a file created by hand. The 'utf8' fixed it.