Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hidden special character causing error in Section Access?

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

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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);


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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);


talk is cheap, supply exceeds demand
Not applicable
Author

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