Tableau 10 Business Intelligence Cookbook

Using schema.ini to resolve data type issues

In this recipe, we will use a schema.ini file to resolve the data types when we connect to a fixed width text file data source with four columns.

Getting ready

To follow this recipe, download this chapter's files from the Packt website and use the file called Fixed Width Sample.txt.

This is what the file looks like when opened in a text editor showing special characters:

Note that this file does not have any column headers. In addition, note the following:

• The first column should be text
• The second column should be integers
• The third column should be text
• The fourth column should be dates

How to do it...

Here are ...