1 of 1 people found this helpful
I wonder if this has anything to do with the Microsoft Jet Database Engine. You can read more here: Resolving Incorrect Data Type Issues | Tableau Software
Some specific symptoms that suggest misinterpreted data types include:
- A field that should display as a dimension appears as a measure.
- A field that should be a string, such as ID, is interpreted as a numeric field (or vice-versa).
- Numbers are interpreted as dates, are rounded incorrectly, and so on.
- Unexpected null values.
Great looking dashboard, by the way!
After reading up on link you provided for resolving incorrect data type issues, it appears as though that is the culprit, but I'm not clear on how I fix my issue.
My workbook is saved in Tableau Desktop 8.2 and my Excel spreadsheet is saved in .xlsx format (Excel 2013).
I created the workbook around the end of 2014/start of 2015, which could have been Tableau 8.1... I'm not sure. If I start my workbook from scratch in 8.2, am I correct in concluding the issue with the Microsoft Jet Database Engine will be resolved? The troubleshoot says to update my Excel file, but I'm not sure what that means given that I'm using the most recent version available (.xlsx),