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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
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.