Last Modified Date: 21 Apr 2019
Environment
- Tableau Desktop
- CSV File
Resolution
- If possible, migrate your data from the CSV file to a more robust data source, such as a relational database. Connecting to a Microsoft Excel file will also correct this issue. Excel will handle duplicate column names by slightly modifying the duplicated column name so that they are all unique.
- Otherwise, create a schema.ini file that will explicitly declare each column header contained in the CSV file. Ensure that this schema.ini file is located in the same folder as the data source. For more information about schema.ini files, refer to the Displaying Data Types Correctly
Cause
One possible cause for this issue is that the missing column has the same name as another column in the data source. The omission of the column is caused by a limitation within the Microsoft JET Database Engine and the rules it uses to retrieve records from text-based files.Additional Information
Note: Jet-based limitations can only occur in workbooks created in Tableau Desktop 8.1 and earlier that use Excel and text file data sources, and workbooks that use the legacy connection and Microsoft Access data sources. To avoid Jet-based issues, consider upgrading your Excel and text file data sources. For more information, see Upgrading Data Sources in Desktop Help.IMPORTANT: Starting in Tableau 2019.1, you can no longer create a new Legacy Excel or Text connection. Existing workbooks created with these legacy connections will continue to work until 2019.2, when all support for legacy connections will be removed. See the Legacy Connection Alternatives document in Tableau Community for alternatives to using the legacy connection.
Discuss this article... Feedback Forum
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials