This schema.ini setting works for me:
Where is this file located? When I search on schema.ini files 1 get 2 temporary files which I cannot update manually...
I cannot seem to locate this schema.ini file. Could it be that this is just included in my registry file or somewhere else? Is there an example file of the schema.ini because when I create it myself and place it next my source file, then Tableau just can't find my 'table' as in filename#txt as a table...
Thanks for checking!
Hi. Create the schema.ini and save it in the same directory that your data file is stored in. Use Sublime Text 2, Notepad++, or any other freely available text editor. If the schema.ini file exists in the same directory as your data file, it is automatically accessed during the read of your data file. You do not need to update the registry or other Windows configuration information.
The thread linked here contains other, useful information.
Are you sure its tab-separated and not comma separated?
yes it is! ;-)
Hi, Bas. Listed below are the steps I'd take at this point. The strategy I'd take: simplify, get it to work on the simplest example possible.
1) Create a new, sample text file that contains one character field and one integer field. Decide if you are using headers or not. I recommend using column headers.
2) Data input just the column headers and three rows of data. Think about whether you are using a comma or tab delimiter. Both the headers and the data have to use the same delimiter.
2) Create a new directory and save the new, sample text file in this new directory.
3) Create a schema.ini for this new, sample text file, and save it in this new directory.
4) Make sure that this schema.ini refers to your sample, text file, and not to your application data file. Edit it so the contents match the file name and field types of your new, sample text file, etc. Refer to this post: http://community.tableau.com/message/248223#248223
5) Don't use the existing workbook that you're using for your application data. Create a new workbook in Tableau.
6) Connect to the data.
Use the freely available Sublime Text 2 or Notepad++ if you are not already doing so. (Don't use the Microsoft Notepad editor.)
If your data connection still doesn't work, refer again to the post referenced above to make sure the delimiter type, etc., match. If it still doesn't work, change the file to use the other type of delimiter and the schema.ini to use the other type of delimiter. In the your editor, search for the delimiter character you used. The editor will highlight all the locations of the character. Make sure the delimiter is where it should be and that there is only one delimiter separating your column headers and your sample data. If it still doesn't work, modify to use just one column of data in the new, sample text file. Modify the schema.ini to match this revision to your data.
Let us know.
Not even a simple file is working now... Again that 'table' does not exist message. Or is there another way I should connect to?
test.txt (tab delimited):
also changing the file to a CSVDelimited file still get's the missing table error...
My next suggestion is to try another data source connection type.
Try Excel. Enter the test data into an Excel worksheet and try connecting to this as the data source.